Registered aircraft · 1,915

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:87-22-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:87-22-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:87-22-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:87-22-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:87-22-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:87-22-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.

N34UPCentral Virginia Aviation Inc · Petersburg, VABuilt 1975 · S/N BC-006 N350TCFobl Inc · Juana Diaz, PRBuilt 1979 · S/N BE-62 N351GRDodson International Parts Inc · Rantoul, KSS/N LW-324 N351KBKabco Aviation LLC · Boaz, ALBuilt 2002 · S/N BB-1904 N351SAGuardian Flight LLC · Lewisville, TXBuilt 1992 · S/N BB1423 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 N354AVAev Aviation LLC · Hilton Head Island, SCBuilt 2002 · S/N LJ-1660 N355PCEagles Wings Avaition LLC · Monroeville, ALBuilt 1984 · S/N LJ-1067 N356ERStraight Flight Nevada Commercial Leasing LLC · Sparks, NVBuilt 1985 · S/N FA-55 N357CCWhitestone Aviation LLC · Orlando, FLBuilt 1982 · S/N LA-180 N35BAC90 Air Inc · Lemoore, CABuilt 1980 · S/N LJ-909 N35CVNavajo Enterprises LLC · Schwenksville, PABuilt 1977 · S/N LW-252 N35HDGuardian Flight LLC · Lewisville, TXS/N LJ-1731 N35TVN35tv LLC · Shawnee, OKBuilt 1972 · S/N LJ-572 N360BLBachman Aviation LLC · Independence, IAS/N BE17 N360EASai Flight Services Inc · Greer, SCS/N BB-1231 N360XNavecord Institute · Wilmington, DES/N BB-1783 N361EAAlcyone Trust Corp Trustee · Wichita, KSS/N BB-1103 N361TDSequoia Beverage Co Lp DBA · Visalia, CABuilt 1986 · S/N BL-128 N3620MSanford Medical Center · Sioux Falls, SDBuilt 1991 · S/N BB-1396 N362MCAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1978 · S/N LJ760 N363DFreeman Holdings Of West Texas LLC · Medford, ORBuilt 1995 · S/N BB-1503 N363JHBering Air Inc · Nome, AKBuilt 2002 · S/N BB-1799 N365CSN365cs LLC · Mcallen, TXS/N FA-120 N366GWK&K Leasing Inc · Tea, SDBuilt 1979 · S/N LW-320 N367SFSuburban Air Freight Inc · Omaha, NEBuilt 1989 · S/N UC-67 N3690FWv Gastro & Endo LLC · Wheeling, WVBuilt 1980 · S/N LJ-921 N3695WSuarez-Ballardo Jorge Luis · Glendale, AZBuilt 1980 · S/N LJ-924 N36987Westflight LLC · Yuma, AZBuilt 2004 · S/N BB-1887 N369RSEarly Bird Air LLC · Lawrence, MIBuilt 1999 · S/N LJ-1571 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 N370CSReach Air Medical Services LLC · Santa Rosa, CABuilt 1996 · S/N BB-1550 N370UBoard Of Regents Of The University Of Oklahoma · Norman, OKS/N LJ-1428 N375JPAir T-Jam LLC · Uniontown, PABuilt 2003 · S/N BB1833 N377JEAcr Advertising LLC · Jasper, INS/N BB-1843 N377PUig Transport LLC · Raleigh, NCBuilt 1984 · S/N LJ-1087 N378ATAirtrex Registration Corp Trustee · Wichita, KSS/N FE-14 N379ATAirtrex Registration Corp Trustee · Wichita, KSS/N FE-15 N379EKAvtrust LLC Trustee · Wilmington, DEBuilt 2001 · S/N BB-1769 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 N3809CRepublic Refrigeration Inc · Monroe, NCBuilt 1981 · S/N LA-112 N380ATAirtrex Registration Corp Trustee · Wichita, KSS/N FE-26 N380JPPaalmc Llv · Shreveport, LAS/N BB-1889

Back to AD 87-22-01 R1