Registered aircraft · 728

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:81-23-01-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-23-01-R1') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:81-23-01-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-23-01-R1')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:81-23-01-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-23-01-R1')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N34CEFirst Call Home Health Agency LLC · Salem, ORBuilt 1981 · S/N LJ-932 N34HAHarper Aerospace LLC · Murfreesboro, TNS/N LM-120 N34MFDavis Aviation Inc · Brandon, MSBuilt 1975 · S/N LW-163 N350TCFobl Inc · Juana Diaz, PRBuilt 1979 · S/N BE-62 N351GRDodson International Parts Inc · Rantoul, KSS/N LW-324 N3532North Delta Ag Aviation LLC · Sledge, MSBuilt 1977 · S/N BE-31 N3536Vantage Aviation USA LLC · Tampa, FLBuilt 1979 · S/N BE72 N3538New Mountain Aviation LLC · Englewood, COBuilt 1978 · S/N BE-57 N3539Thacker Aircraft Holding LLC · Lubbock, TXBuilt 1982 · S/N BE-124 N35BAC90 Air Inc · Lemoore, CABuilt 1980 · S/N LJ-909 N35CVNavajo Enterprises LLC · Schwenksville, PABuilt 1977 · S/N LW-252 N35TVN35tv LLC · Shawnee, OKBuilt 1972 · S/N LJ-572 N3606TSunshine Aero Industries Inc · Crestview, FLBuilt 1970 · S/N B30 N360BLBachman Aviation LLC · Independence, IAS/N BE17 N362MCAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1978 · S/N LJ760 N366GWK&K Leasing Inc · Tea, SDBuilt 1979 · S/N LW-320 N3690FWv Gastro & Endo LLC · Wheeling, WVBuilt 1980 · S/N LJ-921 N3695WSuarez-Ballardo Jorge Luis · Glendale, AZBuilt 1980 · S/N LJ-924 N369WTSterling John · Port Lavaca, TXBuilt 1978 · S/N LW291 N36TGRv Holding LLC · Winchester, MABuilt 1996 · S/N LJ-971 N3700MBoeing Co · Berkeley, MOBuilt 1980 · S/N LW-340 N370PRPuerto Rico International Airlines Inc · San Juan, PRBuilt 1969 · S/N B-6 N377PUig Transport LLC · Raleigh, NCBuilt 1984 · S/N LJ-1087 N379VMShores Kenneth E · Robstown, TXBuilt 1972 · S/N LW-27 N37HDynamic Avlease Inc · Bridgewater, VABuilt 1967 · S/N LM-48 N3805EHollow Creek Investments LLC · Germantown, TNBuilt 1981 · S/N LJ-943 N3818C18 Charlie LLC · Southern Pines, NCBuilt 1976 · S/N LW-196 N38280Aerotrust Services Corp Trustee · Wilmington, DES/N LJ-953 N383AAAzul Air LLC · Dover, DEBuilt 1972 · S/N LW-13 N383ASLee Holdings & Investments LLC · Marks, MSBuilt 1978 · S/N LJ-747 N385EMEmerald Aviation Inc · Manassas, VABuilt 1980 · S/N LJ923 N386GABarnes Inc · Lewiston, IDBuilt 1978 · S/N LJ-775 N388KFKiernan Companies LLC · Englewood, COBuilt 1981 · S/N LW-346 N38VDynamic Avlease Inc · Bridgewater, VABuilt 1968 · S/N LM-105 N390PSMcm Holdings Inc · Lincoln, NES/N LW-279 N390RHAlpine Aviation Inc · Provo, UTS/N U-39 N394ALTeebird Enterprises LLC · Brighton, COBuilt 1968 · S/N LJ394 N399CZN399cz LLC · Milwaukee, WIBuilt 1969 · S/N U-91 N39FBButler National Inc · New Century, KSS/N LJ-1165 N39TNDenaina Leasing Agency LLC · Anchorage, AKBuilt 1968 · S/N U-2 N3DFTaurman Keith L · Virginia Beach, VABuilt 1965 · S/N LJ-36 N3GCTexas Air & Space Museum · Amarillo, TXBuilt 1973 · S/N LJ-576 N3LSConcept Management Company LLC · Spartanburg, SCBuilt 1977 · S/N LW-245 N3XBMonument Aviation LLC · North Chesterfield, VABuilt 1967 · S/N LJ-234 N400RVMach Point Nine LLC · Phoenix, AZBuilt 1979 · S/N LJ-853 N403EMMach Point Nine LLC · Phoenix, AZBuilt 1981 · S/N LJ1000 N404JPParish Planes LLC · Tullahoma, TNBuilt 1982 · S/N LJ-1039 N406CPCalcasieu Parish Police Jury · Lake Charles, LABuilt 1967 · S/N LM-9 N406SFNew Mexico State University · Las Cruces, NMBuilt 1977 · S/N LW-218 N40BA711bn LLC · Miami, FLBuilt 1969 · S/N LJ-444

Back to AD 81-23-01 R1