Skip to content

Registered aircraft · 20,687

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.

N739VND & L Innovations LLC · Hendersonville, TNBuilt 1978 · S/N 17270842 N739VPPaviglianiti Oscar · Durango, COBuilt 1978 · S/N 17270843 N739VRMid-Atlantic Air Ventures Inc · Richmond, VABuilt 1978 · S/N 17270845 N739VSNicol Alan F · Spokane, WABuilt 1978 · S/N 17270846 N739VTChambers Todd R · Brundidge, ALBuilt 1978 · S/N 17270847 N739VVRosev Simeon B · Albuquerque, NMBuilt 1978 · S/N 17270849 N739WAChew Stephen Yk · Honolulu, HIBuilt 1978 · S/N 17270854 N739WBHall Andrew B · Anchorage, AKBuilt 1978 · S/N 17270855 N739WFSkywarrior Flight Training LLC · Pensacola, FLBuilt 1978 · S/N 17270859 N739WHHay Greg L · Conway, ARBuilt 1978 · S/N 17270861 N739WKCooper Co LLC · Tomahawk, WIBuilt 1978 · S/N 17270863 N739WLDorton Aviation LLC · Lebanon, VABuilt 1978 · S/N 17270864 N739WMSundance Aviation Inc · Richland, WABuilt 1978 · S/N 17270865 N739WRRaritan Valley Flying School · Princeton, NJBuilt 1978 · S/N 17270869 N739WXAce Of Spades Aviation LLC · Las Vegas, NVBuilt 1978 · S/N 17270875 N739WYN739wy LLC · Cheyenne, WYBuilt 1978 · S/N 17270876 N739WZWhisky Zulu Inc · Port Washington, NYFirst renewal noticeBuilt 1978 · S/N 17270877 N739XA7550g LLC · Birmingham, MIS/N 17270878 N739XCAllen Danny T · Jonesboro, LABuilt 1978 · S/N 17270880 N739XKAirways Aviation Inc · Grand Rapids, MNBuilt 1978 · S/N 17270887 N739XLFlyrjf LLC · Weirsdale, FLBuilt 1978 · S/N 17270888 N739XMEnstad Ordell J · Goldendale, WABuilt 1978 · S/N 17270889 N739XSGorman Patrick M · Deerfield, OHBuilt 1978 · S/N 17270894 N739XTS O W Aviation LLC · Crystal River, FLS/N 17270895 N739XUTraining Mission Aviation Inc · New Tripoli, PABuilt 1978 · S/N 17270896 N739XVAmaro Mark S · Mi Wuk Village, CABuilt 1978 · S/N 17270897 N739XWWhole Life Wellness Center · Alpine, TXS/N 17270898 N739YESundance Air Services Inc · Alameda, CABuilt 1978 · S/N 17270906 N739YHMelbourne Flight Training LLC · Melbourne, FLBuilt 1978 · S/N 17270909 N739YMHeritage Aviation LLC · Ankeny, IABuilt 1978 · S/N 17270913 N739YRF&O Flight LLC · Calhoun, GABuilt 1978 · S/N 17270917 N739YURrrr Aviation LLC · Bryan, TXBuilt 1978 · S/N 17270920 N739YWPettit Toby B · Morehead, KYBuilt 1978 · S/N 17270922 N739YZSocal Aviation Inc · Chino, CABuilt 1978 · S/N 17270925 N739ZCP&B Aviation LLC · Watkins, COBuilt 1978 · S/N 17270928 N739ZGR & R Aero Services Llcc · Eden Prairie, MNBuilt 1978 · S/N 17270932 N739ZHFreeflight Aviation LLC · Allentown, NJBuilt 1978 · S/N 17270933 N739ZLLefebvre Jeffrey S · Kaneohe, HIBuilt 1978 · S/N 17270936 N739ZNOur Jett LLC · Englewood, COBuilt 1978 · S/N 17270938 N739ZPBlue Sky Aviation LLC · Watkins, COBuilt 1978 · S/N 17270939 N739ZSPryor James A · Bottineau, NDS/N 17270942 N739ZUMelbourne Flight Training LLC · Melbourne, FLBuilt 1978 · S/N 17270944 N739ZWHolladay Aviation LLC · Jacksonville, FLBuilt 1978 · S/N 17270946 N739ZXN739zx Flying Association · Kent, WABuilt 1978 · S/N 17270947 N739ZZR & R Aero Services LLC · Eden Prairie, MNBuilt 1978 · S/N 17270949 N73CHAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13234 N73FRWayman Luy LLC · Weston, FLBuilt 1979 · S/N 17273134 N73LHerald Gregory L · Coatesville, INBuilt 1963 · S/N 17250283 N73MHRainier Flight Service LLC · Renton, WABuilt 2023 · S/N 172S13003 N73MSJohnson Kevin N · Bethpage, NYBuilt 1977 · S/N 17268932

Back to AD 90-06-03 R1