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.

N199PLDodson International Parts Inc · Rantoul, KSBuilt 1976 · S/N LW-167 N19MCFlying B Holdings LLC · Ozona, TXBuilt 1988 · S/N FA-167 N19RZUas Transervices Inc · Boca Raton, FLBuilt 1989 · S/N UC-75 N1GFFlowers George D · Panama City, FLBuilt 1982 · S/N LJ1031 N1LTWhite River Holdings LLC · Southaven, MSS/N BB-1824 N1MARegistered aircraftS/N LA-3 N1NPNebraska Public Power District · Columbus, NES/N BB1834 N1PTWarner Aviation Properties LLC · Austin, TXBuilt 1987 · S/N FA131 N1SMStan Mcnabb Chevrolet Buick Gmc Cadillac Inc · Tullahoma, TNBuilt 2001 · S/N BB-1782 N1UCBas Part Sales LLC · Greeley, COS/N LW-140 N2000EBluebird 2000 LLC · Wilmington, DEBuilt 1966 · S/N LJ-172 N200ANAirtrex Registration Corp Trustee · Wichita, KSBuilt 1979 · S/N BJ-3 N200DAGambill Aviation LLC · Shreveport, LABuilt 1982 · S/N BB-1095 N200EARegistered aircraftBuilt 1990 · S/N BB-1368 N200FMSapphire Air II LLC · Camp Hill, PABuilt 2002 · S/N BB-1794 N200GPWesley Partners II LLC · Mount Vernon, TXBuilt 1994 · S/N BB1496 N200GSNavajo Nation · Window Rock, AZS/N BB--1214 N200HDCooper Container Corp · Maynardville, TNBuilt 1981 · S/N BB-987 N200HKHck Aviation LLC · Jupiter, FLBuilt 2001 · S/N BB-1772 N200JREngelman Acres Ltd · Edinburg, TXBuilt 1983 · S/N BB-1123 N200NDNorth Dakota Department Of Transportation · Bismarck, NDBuilt 1998 · S/N BB-1612 N200NWViking Transport LLC · Saint Louis Park, MNBuilt 1999 · S/N BB-1691 N200PHPrairie Ventures Aviation LLC · Worthington, MNBuilt 1977 · S/N BB-238 N200RELw164 Inc Trustee · Wilmington, DEBuilt 1975 · S/N LW-164 N200RMMps Enterprises LLC · North Platte, NEBuilt 1973 · S/N LW-45 N200RRTexas Dept Of Criminal Justice · Huntsville, TXBuilt 1987 · S/N BB-1282 N200UOhio University · Albany, OHBuilt 1995 · S/N LJ1389 N200UWTrustees Of The University Of Wyoming · Laramie, WYBuilt 1983 · S/N BB-1155 N200WBTurbo Air Charter LLC · Boise, IDS/N BB-1754 N200WPIdplane LLC · Boise, IDBuilt 1991 · S/N BB-1393 N200XCTvpx Ars Inc Trustee · North Salt Lake, UTS/N BB-1061 N200ZZAirtrex Aircraft Charlie Inc · Wichita, KSBuilt 1979 · S/N BC-64 N202FFBeech Transportation Inc · Eden Prairie, MNBuilt 2001 · S/N BB-1786 N202NDNorth Dakota Department Of Transportation · Bismarck, NDBuilt 1998 · S/N BB1611 N2038WYanagida Kazuaki · Norco, CABuilt 1973 · S/N LD-459 N203DHGuardian Flight LLC · Lewisville, TXS/N BB-1845 N203PCEaton Brothers Transportation LLC · Riverside, MOS/N LW-258 N203RDAviation Trust Co LLC Owner Trustee · Oklahoma City, OKBuilt 1976 · S/N LW-203 N2049KUas Transervices Inc · Boca Raton, FLBuilt 1991 · S/N UC-164 N204AFUas Transervices Inc · Boca Raton, FLS/N U-204 N204JTBarbaro Enterprises LLC · Argyle, TXBuilt 1997 · S/N BB1563 N2050ATia Aeronautics Inc · Harlingen, TXBuilt 1978 · S/N LJ-813 N205EJLynch Flying Service Inc DBA · Billings, MTBuilt 1998 · S/N BB-1634 N205MSJustice Air Inc · Farmingdale, NYBuilt 1981 · S/N LJ-948 N205SPState Of Colorado · Englewood, COS/N BB-1826 N205STPate & Pate Air LLC · Andalusia, ALBuilt 1981 · S/N LJ-965 N205TMSmitty'S Supply Inc · Roseland, LABuilt 2007 · S/N BB-1991 N206AVUas Transervices Inc · Boca Raton, FLBuilt 1983 · S/N U-206 N207HBState Of Washington · Olympia, WABuilt 1995 · S/N BB-1516 N207PDale Aviation · Rapid City, SDBuilt 1995 · S/N LJ-1406

Back to AD 87-22-01 R1