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.

N184TXZms Aviation LLC · Wilmington, DEBuilt 1985 · S/N BB-1241 N1857F56 Express LLC · Willmar, MNBuilt 1981 · S/N LA-167 N185MVSouthwest Aviation Inc Div · Marshall, MNBuilt 1982 · S/N BB-1034 N187ALAlm Holdings Delaware 2 LLC · Wilmington, DES/N LJ842 N188Gear Robert Lee III · Paradise Valley, AZS/N LC70 N188LLTriple Aviation LLC · San Leon, TXBuilt 1981 · S/N BE-119 N189ALAlm Holdings Delaware 4 LLC · Wilmington, DES/N BL32 N18AFN220pb LLC · Mesa, AZBuilt 1994 · S/N BB-1497 N18CMEdgewater Aviation LLC · Guntersville, ALBuilt 1984 · S/N LA-219 N18MYWorld Aircraft Leasing Inc · Wilmington, DES/N LJ562 N18SFD&D Maintenance LLC · Etna Green, INBuilt 1985 · S/N LA236 N190BETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1981 · S/N LW-345 N190BHJourney Aviation LLC · Brookland, ARBuilt 1981 · S/N BB-907 N190EBKar King LLC · Huntington, WVBuilt 2005 · S/N BB-1905 N190EFTriple E Farms LLC · Pasco, WABuilt 1985 · S/N LJ-1122 N190FDOreh Aircraft LLC · New Braunfels, TXBuilt 1980 · S/N LA-42 N190GAAlpine Aviation Inc · Provo, UTBuilt 1984 · S/N UB-1 N190JPClearwater Midstream LLC · Lubbock, TXBuilt 1981 · S/N LA-158 N190NCCf Holdings LLC · Hernando, MSBuilt 1982 · S/N LA193 N190PMPlanemasters Ltd · West Chicago, ILBuilt 1986 · S/N UB66 N190RLCamair Leasing LLC · Granbury, TXBuilt 1972 · S/N LW-1 N190SSJ&H Kramer Inc · Redwood City, CABuilt 1992 · S/N LJ1298 N190TTAcme Jet LLC · Dover, DEBuilt 1982 · S/N BB-1005 N190WAAmeriflight LLC · Dallas, TXBuilt 1983 · S/N U-207 N190XTNextant Aerospace LLC · Cleveland, OHBuilt 1984 · S/N LJ-1066 N191AVUas Transervices Inc · Boca Raton, FLBuilt 1982 · S/N U-191 N191CZPlanemasters Ltd · West Chicago, ILBuilt 1986 · S/N UB-59 N191JRLocke-Lane Aviation LLC · Statesville, NCBuilt 1975 · S/N LW144 N1924TUas Transervices Inc · Boca Raton, FLBuilt 1969 · S/N U-115 N192GAAlpine Aviation Inc · Provo, UTS/N UB-17 N193CZPlanemasters Ltd · West Chicago, ILBuilt 1989 · S/N UC-73 N193SUUas Transervices Inc · Boca Raton, FLBuilt 1982 · S/N U193 N194GAAlpine Aviation Inc · Provo, UTBuilt 1984 · S/N UB-8 N194TRExecutive Air Taxi Corp · Bismarck, NDBuilt 1983 · S/N BB-1146 N194YYTj Air Holdings Inc Trustee · Wilmington, DEBuilt 1989 · S/N FA-194 N195ALJmds Lift LLC · Helena, MTBuilt 1986 · S/N FA-102 N196SCChickasaw Transport LLC · Santa Rosa Beach, FLBuilt 1996 · S/N BB-1525 N196WAAmeriflight LLC · Dallas, TXBuilt 1981 · S/N U-179 N196ZZTj Air Holdings Inc Trustee · Wilmington, DES/N FA-196 N197CANighthawk Air Systems Inc · Miami, FLBuilt 1965 · S/N LD-246 N197GAAlpine Aviation Inc · Provo, UTBuilt 1984 · S/N UB-16 N197SCCharlie Ninety Alpha LLC · Searcy, ARBuilt 1997 · S/N LJ-1490 N197WAAmeriflight LLC · Dallas, TXBuilt 1970 · S/N U-130 N198GAAlpine Aviation Inc · Provo, UTBuilt 1984 · S/N UB-5 N198KAThompson Benjamin Kyle · Nevada, TXBuilt 1966 · S/N LJ-162 N199BCAirco King LLC · Wichita Falls, TXBuilt 1980 · S/N LA-30 N199CGGuardian Flight LLC · Lewisville, TXBuilt 2002 · S/N LJ-1661 N199DWAeon62 Holdings LLC · Plano, TXBuilt 1980 · S/N LW-338 N199MHGsg Aviation LLC · Fort Lauderdale, FLBuilt 1981 · S/N BB-855 N199NDDodson International Parts Inc · Rantoul, KSS/N BP-025

Back to AD 87-22-01 R1