Skip to content

Registered aircraft · 54,015

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-20-03-R2') 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-20-03-R2') 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-20-03-R2')
    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-20-03-R2')
  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-20-03-R2')
  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-20-03-R2')
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.

N737FXZborowski Ronald W · Eighty Four, PABuilt 1978 · S/N R18200825 N737FYMiller Davette D · Mesa, AZBuilt 1979 · S/N R18200826 N737GAN737ga LLC · Jupiter, FLS/N 17269396 N737GCDiamond Aircraft Sales Of Kentucky LLC · Henderson, KYBuilt 1977 · S/N 17269398 N737GDEfc Aviation LLC · Lancaster, KYBuilt 1979 · S/N R18200827 N737GEFlying Neutrons LLC · Lebanon, OHBuilt 1977 · S/N 17269400 N737GJJaars Inc · Waxhaw, NCS/N 17269404 N737GKGeneral Aviation LLC · Henderson, NVBuilt 1977 · S/N 17269405 N737GLFlying Panthers Flight School Inc · Citrus Heights, CABuilt 1977 · S/N 17269406 N737GMFive Rivers Flight Training LLC · Livermore, CABuilt 1977 · S/N 17269407 N737GPWilliams Allen E · Redlands, CABuilt 1977 · S/N 17269409 N737GRRick Aviation Inc · Newport News, VABuilt 1977 · S/N 17269411 N737GSRising Wings Aviation Inc · Casper, WYBuilt 1977 · S/N 17269412 N737GUWings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 17269414 N737GVTas Aviation Of Defiance Inc · Defiance, OHBuilt 1977 · S/N 17269415 N737GZSauk Valley Aviation Inc · Sterling, ILBuilt 1977 · S/N 17269419 N737HDNotam Aviation LLC · Portage Des Sioux, MOBuilt 1977 · S/N 17269422 N737HELaurel Highlands Aeronautical Academy · Latrobe, PABuilt 1977 · S/N 17269423 N737HGGuyair Inc · Saint Charles, MOBuilt 1977 · S/N 17269425 N737HHG A W Flying Club Corp · Palos Heights, ILBuilt 1977 · S/N 17269426 N737HJPersonal Aviation Inc · Poway, CABuilt 1977 · S/N 17269427 N737HMMeyer Raymond · Ukiah, CABuilt 1977 · S/N 17269430 N737HNAvey Gregory B · Saint John, INBuilt 1979 · S/N R18200829 N737HPLinn Anthony B · Westborough, MABuilt 1979 · S/N R18200830 N737HUBerry William J · Troy, MIBuilt 1978 · S/N R18200832 N737HVSchuler Eric C · Fort Salonga, NYBuilt 1977 · S/N 17269438 N737HWCag Aircraft Holdings LLC · Crystal River, FLBuilt 1977 · S/N 17269439 N737HYSeven 4 Zulu LLC · San Diego, CABuilt 1977 · S/N 17269441 N737JBemis Susan · Newhall, CABuilt 1978 · S/N R18200842 N737JHMcdermotts Letsfly LLC · Somerton, AZBuilt 1977 · S/N 17269449 N737JJAvid Aviation LLC · Gilbert, AZBuilt 1977 · S/N 17269450 N737JKJuliet Sierra Foxtrot LLC · Denver City, TXBuilt 1978 · S/N R18200836 N737JLN737jl LLC · Dimmitt, TXBuilt 1978 · S/N R18200837 N737JMMccormack June · Borrego Springs, CABuilt 1977 · S/N 17269601 N737JNSurplus Products Inc · East Point, KYBuilt 1978 · S/N R18200838 N737JQPorter Timothy Charles · Bloomington, INS/N 17269456 N737JRG&M Aircraft Inc · Wheat Ridge, COBuilt 1977 · S/N 17269457 N737JSBoren Aviation LLC · Knoxville, TNBuilt 1978 · S/N R18200839 N737JTColman Ronin B · Arlington, TXBuilt 1978 · S/N R18200840 N737JUFussell Tracy L · Mc Rae, GABuilt 1977 · S/N 17269460 N737JXR&R Aero Services LLC · Eden Prairie, MNBuilt 1977 · S/N 17269463 N737JYWright Robert Gene · Kearney, MOBuilt 1977 · S/N 17269464 N737KCH & H Aviation Enterprises LLC · Fairfield, OHBuilt 1977 · S/N 17269468 N737KE247 Aviation LLC · Palm Coast, FLBuilt 1977 · S/N 17269470 N737KGRamp 106 LLC · Lynn Haven, FLBuilt 1977 · S/N 17269472 N737KJRed-Tailed Hawks Aviation Academy · Mukilteo, WAS/N 17269474 N737KMSmith Daryl N · Coventry, CTBuilt 1977 · S/N 17269477 N737KPPhill-Air Inc · Dover, DEBuilt 1968 · S/N 15067475 N737KQZuidema Herbert L Trustee · Redding, CABuilt 1977 · S/N 17269480 N737KWJcil LLC · Hudsonville, MIBuilt 1977 · S/N 17269486

Back to AD 87-20-03 R2