Skip to content

Registered aircraft · 22,430

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-08-08-R3') 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-08-08-R3') 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-08-08-R3')
    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-08-08-R3')
  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-08-08-R3')
  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-08-08-R3')
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.

N165JYSt Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1977 · S/N 28-7890225 N165LHRochester Air Center LLC · Canandaigua, NYBuilt 2011 · S/N 2844144 N165PPiper Aircraft Inc · Vero Beach, FLS/N 28020290 N165RTxav8r LLC · Houston, TXBuilt 1977 · S/N 32R7885217 N1660HAtd Pilot Training LLC · Kansas City, MOS/N 28-7716037 N1661HRed Tail Scholarship Foundation · Tuskegee, ALS/N 28-7790325 N1662JAltaverde LLC · Port Orange, FLBuilt 1967 · S/N 28-24059 N1663HSecure Uicc Corp · Glen Burnie, MDS/N 28R-7737007 N1666JHutchinson George · Wolfeboro, NHBuilt 1967 · S/N 28-24064 N1668Paragon Airplane Leasing Co · Fort Myers, FLBuilt 2024 · S/N 28020178 N1668JJimenez Bryan · Los Angeles, CABuilt 1968 · S/N 28-24068 N166AZJantzon Markus I F · Kingwood, TXBuilt 1969 · S/N 28-11320 N166CBStar Ground Services Inc · Tinian, MPBuilt 1973 · S/N 32-7440032 N166LHFarmingdale State College · Farmingdale, NYBuilt 2020 · S/N 2881373 N166NGVaught Timothy A · Mauldin, SCBuilt 1975 · S/N 32-7500016 N166RBMf Plane Management LLC · Wesley Chapel, FLBuilt 1974 · S/N 32-7440138 N1671HBarth Samuel · Fonda, NYS/N 28R-7737008 N1673HTronerud Jason · Maple Grove, MNBuilt 1977 · S/N 32-7740037 N1673JSouthern Colorado Flight Professionals LLC · Pueblo, COBuilt 1967 · S/N 28-24074 N1674JCaloon John H · Greenfield, MABuilt 1968 · S/N 28-24075 N1675HIcarus Flying Academy LLC · Farmingdale, NYBuilt 1977 · S/N 28-7716040 N1675JTevis Aviation Inc · Emporia, KSBuilt 1967 · S/N 28-24076 N1676HClass Bee Inc · Pensacola, FLS/N 28-7716041 N1677JCross X Country LLC · Great Falls, VABuilt 1968 · S/N 28-24078 N1678HBrown Gregory B · New London, CTBuilt 1977 · S/N 28-7790330 N1678JCloudhoppers Inc · Effingham, ILBuilt 1967 · S/N 28-24079 N1679HLake Elmo Aero LLC · Lake Elmo, MNS/N 28-7790331 N1680HShimkus Aviation LLC · Tupelo, MSS/N 28R-7703031 N1682JBeatty Gary A · Mosinee, WIFirst renewal noticeBuilt 1967 · S/N 28-24083 N1683JMiranda Emigdio · El Dorado Hills, CAS/N 28-24084 N1684HPlane Folks LLC · Tucson, AZBuilt 1977 · S/N 28-7725154 N1684JJarriel Investments Inc · Register, GABuilt 1967 · S/N 28-24086 N1686JPatterson John E · Jacksonville, ILBuilt 1967 · S/N 28-24088 N1687JMarsh Flyers LLC · Britton, SDBuilt 1968 · S/N 28-24089 N1688HAbsolute Imaging Inc · Corona, CABuilt 1977 · S/N 28-7790332 N1688JTalley Charles B · Ignacio, COS/N 28-24091 N1688TCape May Aero LLC · Cape May, NJBuilt 1970 · S/N 28-7125005 N1689HIxi LLC · West Bloomfield, MIS/N 28-7790333 N1689JHouff Christopher J · Mount Crawford, VABuilt 1968 · S/N 28-24092 N1689TFun Flyers LLC · Rapid City, SDBuilt 1970 · S/N 28-7125006 N168BLWingsleasing LLC · Wichita, KSBuilt 2024 · S/N 2881768 N168DPJohnson Eldridge Jr · Chicago, ILBuilt 1967 · S/N 28-4402 N168FReading Aero Club Inc · Reading, PABuilt 1999 · S/N 2843264 N168KWWalsh Home Improvement Co Inc · Berlin, MDBuilt 1972 · S/N 28-7305031 N168LHFarmingdale State College · Farmingdale, NYBuilt 2020 · S/N 2881374 N1690THutchison Harry L · Grandview, MOS/N 28-7125007 N1691HButterfield Arthur W Jr · Holland, MIS/N 28R-7703032 N1691JBaldwin Rickey Albert · Clarksville, VAS/N 28-24094 N1692JMalkowski Joseph S Trustee · Lake Saint Louis, MOBuilt 1967 · S/N 28-24096 N1692TDhawan Gautam · Madison, MSBuilt 1970 · S/N 28-7125009

Back to AD 87-08-08 R3