Skip to content

Registered aircraft · 22,413

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.

N41575Boyd Darrell A · Arlington, TNS/N 28-7415279 N41579Walker John Brandon · Thaxton, MSBuilt 1974 · S/N 32-7400034 N41583Files Barbara E · Hopkinton, MABuilt 1974 · S/N 28-7415282 N41585Bas Part Sales LLC · Greeley, COBuilt 1974 · S/N 28R-7435203 N41589Elder David R · Tuscaloosa, ALBuilt 1974 · S/N 28-7415140 N41593Flyin LLC · Hyde Park, UTS/N 28-7415286 N41598Fox Flying Club Inc · Wheaton, ILBuilt 1999 · S/N 2843290 N4159RArmstrong Scott T · Navasota, TXBuilt 1968 · S/N 32-40474 N4159WNorthern Sky Aviation LLC · Howard Lake, MNBuilt 1967 · S/N 32-40231 N415CAFly For Fun Aircraft LLC · Baltimore, MDS/N 2843215 N415CFAlo Fliteline Lc · Waterloo, IABuilt 1975 · S/N 28-7505118 N415GKCentral Clinton County Flying Club Inc · Jersey Shore, PABuilt 1982 · S/N 28-8290151 N415KMTmjb Holdings LLC · Chandler, AZS/N 28-8390081 N415LLost Pines Tours LLC · Bastrop, TXBuilt 1977 · S/N 32-7740073 N415MSNextgen Flight Academy Inc · Riverside, CABuilt 1978 · S/N 28-7816430 N415PABird Acquisition LLC · Phoenix, AZBuilt 2001 · S/N 2843448 N415SGriffing Flying Service Inc · Port Clinton, OHBuilt 1978 · S/N 28-7990041 N415WHPaavola Troy E · Kansas City, MOS/N 28R-7435199 N41604Schuur Rodney E · Slayton, MNBuilt 1974 · S/N 28-7415290 N41606My Flight LLC · Cypress, TXS/N 287415291 N41609Worthington John F II · Russiaville, INBuilt 1974 · S/N 28-7405124 N4160FYatin Servet · Weston, MABuilt 2000 · S/N 2844028 N4160JIvy James E · Alba, TXS/N 28-22489 N41614Cartier Edward J Jr · Columbia, MSS/N 28-7415294 N41618Evv Warrior LLC · Evansville, INBuilt 1974 · S/N 28-7415295 N41619Charles City Aeronautics Inc · Charles City, IABuilt 1974 · S/N 28-7415296 N4161JRegistration Pending · Hardinsburg, KYRegistration pendingBuilt 1966 · S/N 28-22490 N4161PRegistered aircraftBuilt 1999 · S/N 2843309 N4161ZAri Ben Aviator Inc · Fort Pierce, FLBuilt 1998 · S/N 2843129 N41622Stingray LLC · Kalispell, MTBuilt 1974 · S/N 28-7415297 N41623Airplanesusa LLC · Schaumburg, ILBuilt 1974 · S/N 28-7405126 N4162REckman Jason · Waterford, WIBuilt 1968 · S/N 32-40477 N4162WBas Part Sales LLC · Greeley, COBuilt 1967 · S/N 32-40235 N4162ZSpirit Flyers Inc · Saint Louis, MOBuilt 2000 · S/N 3257127 N41639Airmotive Service LLC · Brigham City, UTBuilt 1974 · S/N 28-7415299 N4163DMiraza Aviation LLC · Longview, TXBuilt 2000 · S/N 32-57145 N4163EAllied Aviators Inc · Allison Park, PABuilt 2000 · S/N 3257136 N4163FHammans Gail A · Hot Springs, ARBuilt 1976 · S/N 28-7725003 N4163JLoera Josa · Laredo, TXS/N 28-22493 N4163RFlying Javelina Aero-Club · Tucson, AZBuilt 1968 · S/N 32-40478 N4163WRedlands Flying Club · Redlands, CABuilt 1998 · S/N 2843127 N41641Gunderson Roger · Fort Collins, COBuilt 1999 · S/N 2843276 N41645Coastal Air Inc · Groton, CTBuilt 1974 · S/N 28-7405128 N41648Russell Matthew M · Niantic, CTBuilt 1974 · S/N 28-7415304 N41649Air Trek North LLC · South Saint Paul, MNBuilt 1974 · S/N 28-7415305 N4164JCaister Benjamin M · Saint Clair, MIS/N 28-22494 N4164YBoard Of Trustees · Savoy, ILBuilt 2000 · S/N 2843317 N41650Airmotive Service LLC · Brigham City, UTBuilt 1974 · S/N 28-7415306 N41657Morton Zac D · San Antonio, TXBuilt 1974 · S/N 28-7415308 N4165EJauer Brant A · Saukville, WIBuilt 1999 · S/N 2843291

Back to AD 87-08-08 R3