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.

N900MXTropical Transport Services Ltd Inc · San Juan, PRBuilt 1986 · S/N UB-55 N901DDTdbd Holdings LLC · Lexington, NES/N LJ-1726 N901JEDodson International Parts Inc · Rantoul, KSBuilt 1982 · S/N LJ-1030 N901LMLifeflight Of Maine LLC · Bangor, MEBuilt 1999 · S/N BB-1693 N901PSDavis Aviation Inc DBA · Brandon, MSBuilt 1979 · S/N LA-5 N901SFSingleton Investments LLC · Menlo Park, CABuilt 2004 · S/N BB-1859 N901TMMatanane Roke C · Barrigada, GUBuilt 1977 · S/N LW-227 N901WLBas Part Sales LLC · Greeley, COBuilt 1968 · S/N LJ-410 N9029RArx Aviation LLC · Eustis, FLBuilt 1975 · S/N LW-132 N902DBBank Of Utah Trustee · Salt Lake City, UTBuilt 1989 · S/N LJ1202 N902MBB & M Aviation LLC · Bonneau, SCBuilt 1974 · S/N LW-105 N903MDMaryland Department Of Agriculture · Annapolis, MDBuilt 1968 · S/N LM-98 N903TWTwi Air LLC · Picayune, MSS/N BB-1822 N904DGCentral Virginia Aviation Inc · Petersburg, VAFirst renewal noticeBuilt 1983 · S/N BB-1176 N904DKAerolease LLC · Fargo, NDBuilt 1984 · S/N LJ-1089 N904HBohanon Air LLC · Jonesboro, ARBuilt 1979 · S/N LW-239 N904HBState Of Louisiana · Baton Rouge, LABuilt 1990 · S/N LJ-1256 N904PSpeed Aviation Inc · Bay Minette, ALBuilt 1988 · S/N LJ1181 N904PB34 Bravo LLC · Pine Bluff, ARBuilt 1981 · S/N LJ-962 N904RBColumbia Flight Group LLC · Columbia, MOBuilt 1985 · S/N LJ-1088 N904SHSanford Medical Center · Sioux Falls, SDBuilt 1998 · S/N BB-1614 N904THFlying Petroleum LLC · El Dorado, ARS/N LJ-1680 N905NYAzul Air LLC · Dover, DEBuilt 1972 · S/N LW-6 N905SHSanford Medical Center · Sioux Falls, SDS/N BB-1582 N906DCHarrington Douglas R Jr · League City, TXFirst renewal noticeBuilt 1982 · S/N BB-1094 N906HFCavanaugh Air LLC · Addison, TXBuilt 1971 · S/N LM-140 N906MRMarc Aircraft Holding LLC · Soldotna, AKS/N LM-136 N907DBErics Leading Edge Inc · St George, UTBuilt 1985 · S/N FA-85 N907GSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1981 · S/N BB-905 N908KPetors John W · Addison, TXBuilt 1970 · S/N LJ-504 N908MHMeadows Homes Inc · Cookeville, TNBuilt 2001 · S/N BB-1781 N909EBBaloian Packing Company Inc · Fresno, CAS/N LJ-1688 N909MJSteel Rock Services LLC · Taylorsville, MSBuilt 1987 · S/N LJ-1151 N90AMTexas A And M University · College Station, TXBuilt 1989 · S/N BB-1328 N90AWAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1976 · S/N LJ-697 N90CNPrice Services Inc · Monticello, ARBuilt 1995 · S/N LJ-1410 N90CTToccoa Group LLC · Odessa, FLBuilt 1974 · S/N LJ-645 N90CXRock Hard Aviation LLC · Mclean, VABuilt 1999 · S/N LJ-1583 N90DDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1970 · S/N LU-10 N90DNNational Aerotech Aviation Delaware Inc · Wilmington, DEBuilt 1969 · S/N LJ-437 N90ELTrue Airspeed LLC · Pace, FLBuilt 1973 · S/N LJ-592 N90FAirborne Flight Ops Inc · Reno, NVS/N LA-235 N90FAFox Valley Technical College · Appleton, WIBuilt 1966 · S/N LJ-133 N90HKSantana Trading LLC · Edinburg, TXBuilt 1982 · S/N LA-176 N90JNScg Leasing LLC · Owensboro, KYBuilt 1973 · S/N LW-74 N90JZEmerald Coast Sunsets LLC · Miramar, FLBuilt 1990 · S/N LJ-1239 N90KALj369 LLC · Opa Locka, FLBuilt 1968 · S/N LJ-369 N90KSRelease The Twins LLC · Longview, TXBuilt 1998 · S/N LJ-1517 N90LBMaza Flight LLC · Wilmington, DEBuilt 1973 · S/N LJ-573 N90MEMonument Aviation LLC · North Chesterfield, VABuilt 1975 · S/N LJ-661

Back to AD 87-22-01 R1