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.

N5390TBakker Johanna · Spokane, WABuilt 1964 · S/N 17251290 N5390VSpringfield Flying Service LLC · Columbia, CABuilt 1980 · S/N 172RG0518 N5391HHansen Alvin Kent · Winamac, INBuilt 1975 · S/N 17265419 N5392TStarkovich James M · Arlington, WABuilt 1964 · S/N 17251292 N5393VPeterson Gary E · Bainbridge Island, WAS/N 172RG0519 N53945Lewis Robert · Chandler, AZBuilt 1981 · S/N 17274832 N5394TBigler Danny L · Owasso, OKBuilt 1964 · S/N 17251294 N5395HHansen James R · Kenmore, WABuilt 1975 · S/N 17265421 N5396ESorbi Aviation Inc · El Cajon, CABuilt 1978 · S/N 17271842 N5396RPrecocity Academy LLC · Gibsonia, PABuilt 1965 · S/N 17252933 N5396TMclaughlin Daniel J · Elbridge, NYBuilt 1964 · S/N 17251296 N5397DRandall William G · Oklahoma City, OKS/N 17272563 N5397RIowa Lakes Community College · Estherville, IABuilt 1974 · S/N 17263530 N5398TSandstrom Mark · Minot, NDBuilt 1964 · S/N 17251298 N53996Pea-Wayman Flight LLC · Daytona Beach, FLBuilt 1981 · S/N 17274836 N5399JMann Aviation Inc · Long Beach, CAS/N 17273779 N5399KColemanation Investments LLC · Naperville, ILBuilt 1980 · S/N 17274095 N539KSKent State University · Stow, OHBuilt 2015 · S/N 172S11646 N539MTFlyboys LLC · Fall City, WABuilt 1962 · S/N 17249604 N539NDAerosim Academy Inc · Sanford, FLBuilt 2008 · S/N 172S10850 N539PBHumphrey Daryle C · Graford, TXS/N 17264402 N53AAMustang Sally Aviation LLC · Camden, SCBuilt 2016 · S/N 172S11737 N53FBBiniewicz Frank B · Downers Grove, ILBuilt 1979 · S/N 17273291 N53FFWingsleasing LLC · Wichita, KSBuilt 2022 · S/N 172S12876 N53JVan Way Dillion J · Lafayette, LABuilt 1979 · S/N 17272890 N53LULetourneau University · Longview, TXBuilt 2024 · S/N 172S13200 N54003Albuquerque Aviation Academy · Albuquerque, NMBuilt 1981 · S/N 17274838 N5400HF & J Air LLC · Abbeville, SCBuilt 1975 · S/N 17265423 N5400JErwa Mohamed E · Leander, TXBuilt 1980 · S/N 17273780 N5400TDonnelly Charles R · Nashua, NHBuilt 1964 · S/N 17251300 N54011United States Air Force (Owner) · Dover Afb, DEBuilt 1981 · S/N 17274842 N54012Carelli Alfred J · Ocala, FLBuilt 1981 · S/N 17274843 N54015Northwoods Air LLC · Orono, MEBuilt 1981 · S/N 17274845 N5401HDms Leasing Company LLC · Las Vegas, NVBuilt 1975 · S/N 17265424 N5402EOsprey Holding Company LLC · Foley, ALBuilt 1978 · S/N 17271845 N5402RBarsto Aviation Inc · Wilmington, DEBuilt 1974 · S/N 17263535 N54031Mlr Adventures Inc · Wilmington, DEBuilt 1981 · S/N 17274851 N54036Missions Unlimited Of Oregon Inc DBA · Harrah, OKBuilt 1981 · S/N 17274852 N5403RPeterson Matthew · Overland Park, KSBuilt 1965 · S/N 17252941 N5403TIngrim William Paul · Girdwood, AKBuilt 1964 · S/N 17251303 N5403VL & R Consulting LLC · Las Vegas, NVBuilt 1980 · S/N 172RG0521 N54041Bowen John E · Ocala, FLBuilt 1981 · S/N 17274855 N54048Hodge Flight Services LLC · Pittsburgh, CABuilt 1981 · S/N 17274857 N54049Pittinger Mitchell J · Reisterstown, MDBuilt 1981 · S/N 17274858 N5404RKoller Rex E · Athens, ALS/N 17252942 N5404TCorrea Ruben D · Horn Lake, MSS/N 17251304 N5405RPolson Taylor M · Killeen, TXBuilt 1965 · S/N 17252943 N5405TAgt Tech Corp · Hialeah, FLNon-citizen corporation, flight hours not reportedS/N 17251305 N54067St Pete Aviation Services LLC · Saint Petersburg, FLS/N 17274866 N5406RMmm Enterprises LLC · Aurora, INBuilt 1965 · S/N 17252945

Back to AD 90-06-03 R1