Skip to content

Registered aircraft · 22,416

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.

N764NDUniversity Of North Dakota · Grand Forks, NDBuilt 2017 · S/N 2843894 N7650JAmsg Transport LLC · Southfield, MIS/N 28R-31050 N7651FAishvaryam LLC DBA · Lancaster, TXBuilt 1976 · S/N 28-7715224 N7651HGosbrook Aviation LLC · Lewes, DEBuilt 1973 · S/N 32-7440025 N7652FProfessional Aviation Aircraft Services Ltd · New Philadelphia, OHBuilt 1976 · S/N 28-7715225 N7652JCamilo Rafael Gonzalez Moya · Fort Worth, TXS/N 28R-31052 N7652WCarlson Justin Q · Sheridan, WYBuilt 1964 · S/N 28-1629 N7653FHyldburg Aviation Inc · Plymouth, MABuilt 1976 · S/N 28-7790205 N7653JGulley Peter M · Karnes City, TXBuilt 1969 · S/N 28R-31053 N7653WHernandez Kelvin · Wilkes Barre, PABuilt 1964 · S/N 28-1630 N7654JGarrison Trading LLC · Prescott, AZBuilt 1969 · S/N 28R-31054 N7655FShining Star Aviation LLC · Zephyr Cove, NVBuilt 1976 · S/N 32-7740015 N7655WRajh Cody · Chino, CABuilt 1964 · S/N 28-1633 N7656JBurton David N · Pittsgrove, NJBuilt 1968 · S/N 28R-31056 N7656WPchg Aviation LLC · Richmond, UTBuilt 1964 · S/N 28-1635 N7657WCrouse David E · Shrewsbury, MABuilt 1964 · S/N 28-1636 N7658JGarner Kenneth W · Decatur, ALBuilt 1969 · S/N 28R-31058 N7659FCharles City Aeronautics Inc DBA · Charles City, IAS/N 28-7715227 N7659JEdwards Robert B Jr · Macon, GABuilt 1968 · S/N 28R-31059 N7659WHutain Ronald P · Van Buren, ARBuilt 1964 · S/N 28-1619 N765CBJillco Enterprises Inc · Wilmington, DEBuilt 1971 · S/N 28R-7135052 N765LBScott Jacob A · Paso Robles, CABuilt 1965 · S/N 282530 N765NDUniversity Of North Dakota · Grand Forks, NDBuilt 2017 · S/N 2843895 N7660FDoughty Kirk T · Grapeview, WABuilt 1976 · S/N 28-7715228 N7660WMelberg Bruce W · Weatherford, TXBuilt 1964 · S/N 28-1590 N7661FBass Fred Lee III · Birmingham, ALBuilt 1976 · S/N 28-7715229 N7661JMitchell Edson · El Dorado Hills, CABuilt 1970 · S/N 28R-31061 N7661WLund Dana K · West Covina, CABuilt 1964 · S/N 28-1622 N7662FFreeman Mark J · Discovery Bay, CABuilt 1976 · S/N 28-7715230 N7662JBurns Christopher Jason Gary · Natrona Heights, PABuilt 1969 · S/N 28R-31062 N7663FBandstra James R · Big Rapids, MIBuilt 1976 · S/N 28-7790209 N7664FSkyfusion II LLC · Atlanta, GABuilt 1976 · S/N 28-7790210 N7664JTrue Arrow Aviation LLC · Cloverdale, CABuilt 1970 · S/N 28R-31063 N7665CIndian Hills Community College · Ottumwa, IABuilt 1975 · S/N 28-7615059 N7666JCavallaro Jack C · Jordan, NYBuilt 1968 · S/N 28R-31065 N7666WFields Steve · Versailles, MOBuilt 1964 · S/N 28-1644 N7667CDoral Aviation LLC · Jefferson Hills, PABuilt 1975 · S/N 28-7690074 N7667WRegistration Pending · Hickman, CARegistration pendingBuilt 1964 · S/N 28-1645 N7668FAdams Carl · Vincennes, INBuilt 1976 · S/N 28-7715232 N7668WGhahramanians Serjik · Sunland, CABuilt 1964 · S/N 28-1647 N766GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881463 N766LAN766la LLC · Philadelphia, PABuilt 2025 · S/N 28020218 N766NDGfk Wings LLC · Grand Forks, NDBuilt 2017 · S/N 2843896 N766VKWave Golf LLC · Kimberly, ALBuilt 1977 · S/N 32R-7780271 N7670FAkaya LLC · Sherman Oaks, CABuilt 1976 · S/N 28-7790214 N7670WSergeant Chess M · Dothan, ALBuilt 1964 · S/N 28-1651 N7671FPedal Valves Inc · Luling, LABuilt 1976 · S/N 32-7740016 N7672JWeiner Johannes · New Paltz, NYBuilt 1969 · S/N 28R-31103 N7672WCrossroads Aviation LLC · Leesville, LABuilt 1964 · S/N 28-1653 N7673WNew Horizons Aviation Inc · Goshen, INBuilt 1964 · S/N 28-1656

Back to AD 87-08-08 R3