Skip to content

Registered aircraft · 20,683

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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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.

N20068Spartanburg Area Flight Education LLC · Spartanburg, SCBuilt 1972 · S/N 17260980 N20069Montel Richard D · Candler, NCBuilt 1972 · S/N 17260981 N20070Skywarrior Flight Training LLC · Pensacola, FLS/N 17260982 N20071Limaoscar LLC · Boca Raton, FLBuilt 1972 · S/N 17260983 N20072Ace Aviation 20072 LLC · Pembroke Pines, FLBuilt 1972 · S/N 17260984 N20073Gulf Coast Aviators LLC · Venice, FLBuilt 1972 · S/N 17260985 N20074Kyzer Aviation Holdings LLC · Fort Mill, SCBuilt 1972 · S/N 17260986 N20079Celestial Kinetics Flight Academy LLC · Waupaca, WIBuilt 1972 · S/N 17260990 N2007XEpic Aviation Inc · Denison, TXBuilt 2025 · S/N 172S13447 N2007YFoster Lemuel E · Vancouver, WABuilt 1962 · S/N 17249507 N20089Eagle Air Inc · Schoolcraft, MIBuilt 1972 · S/N 17260999 N20091Henderson Norman L · Bowling Green, MOBuilt 1972 · S/N 17261001 N20093Patterson Kyle · Tega Cay, SCBuilt 1972 · S/N 17261003 N20095Wingsleasing LLC · Wichita, KSBuilt 1972 · S/N 17261005 N20097Morrison Robert J · Newport, MIBuilt 1972 · S/N 17261006 N200PFPrimary Flight Control LLC · Fleming Island, FLBuilt 1984 · S/N 17276085 N200ZKInternational Air Services Inc Trustee · Carson City, NVBuilt 1966 · S/N 17255678 N20102Wings Over Texas Holdings LLC · Denton, TXBuilt 1972 · S/N 17261010 N20106Atlanta Air Academy LLC · Kennessaw, GABuilt 1972 · S/N 17261014 N20111Westcott Emily E · Sequim, WABuilt 1972 · S/N 17261019 N20115Alpha Zulu Aviation LLC · San Diego, CABuilt 1972 · S/N 17261021 N20121Fly Maui LLC · Puunene, HIBuilt 1972 · S/N 17261025 N20123Irungu Gitau · Charlotte, NCBuilt 1972 · S/N 17261027 N2012EAirgo Inc · Centralia, ILBuilt 1978 · S/N 17271117 N2012FEpic Aviation Inc · Denison, TXBuilt 2025 · S/N 172S13452 N20132J & L Aviation LLC · Malta, NYBuilt 1972 · S/N 17261035 N20133Creative Strategies Inc · Proctorville, OHBuilt 1972 · S/N 17261036 N20136Crate Inc · Humboldt, NEBuilt 1972 · S/N 17261038 N2013WEpic Aviation Inc · Denison, TXBuilt 2025 · S/N 172S13451 N2013YRoberts Michael R · Plano, TXBuilt 1962 · S/N 17249513 N20141Bbrrjd Inc · Wilmington, DEBuilt 1972 · S/N 17261042 N20143Loomis Aviation LLC · Gahanna, OHBuilt 1972 · S/N 17261044 N2014EWanda Collins Professional Pilot Services LLC · Madisonville, TXBuilt 1978 · S/N 17271118 N20154Jones 170a LLC · Bridgman, MIBuilt 1972 · S/N 17261051 N20155Wild Wingdom LLC · Greenville, SCBuilt 1972 · S/N 17261052 N20157Kelley Aircraft LLC · Weyers Cave, VABuilt 1972 · S/N 17261053 N20158Vbp Services LLC · Wainscott, NYBuilt 1972 · S/N 17261054 N20159Western Edge Aviation LLC · Dickinson, NDBuilt 1972 · S/N 17261055 N2015YHoing Randal H Jr · Mexia, TXBuilt 1962 · S/N 17249515 N20169R D T Aviation Inc · Williston, VTBuilt 1972 · S/N 17261062 N2016FEpic Aviation Inc · Denison, TXBuilt 2025 · S/N 172S13450 N20172Queen City Aero Club Inc · Chelmsford, MABuilt 1972 · S/N 17261065 N20175Jet Air Solutions Inc · Fort Myers, FLS/N 17261068 N20176Greenwood David L · Garrettsville, OHBuilt 1972 · S/N 17261069 N20177Nashville Flight School LLC · Nashville, TNBuilt 1972 · S/N 17261070 N20178Christopher Sandra A · Mabel, MNBuilt 1972 · S/N 17261071 N20181Mile High Aviation · Saint Peter, MNBuilt 1972 · S/N 17261074 N20182Gillies David K · Raymond, MEBuilt 1972 · S/N 17261075 N20183Registered aircraftBuilt 1972 · S/N 17261076 N20185Woodhams Jonathon R · South Haven, MIBuilt 1972 · S/N 17261078

Back to AD 90-06-03 R1