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.

N6175GKimber 123 Holdings LLC · Morgantown, WVBuilt 1979 · S/N 17273574 N61760Little Duane V · Puyallup, WABuilt 1975 · S/N 17264781 N61761Hawk Aviation Inc · Rush City, MNBuilt 1975 · S/N 17264782 N61763Bortoto Da Silva Alexandre · Fort Lauderdale, FLBuilt 1975 · S/N 17264784 N61765Dean Mark T · Van Alstyne, TXBuilt 1975 · S/N 17264785 N61769Jackson Lynn B · Cocoa Beach, FLBuilt 1975 · S/N 17264787 N6176EBullit Enterprises Ltd · Wshngtn Ct Hs, OHS/N 46276 N6176GGaruda Flight Training LLC · Miami, FLBuilt 1979 · S/N 17273575 N61770Mwbw LLC · Shawano, WIBuilt 1975 · S/N 17264788 N61772Henry Donald R · Lake Stevens, WABuilt 1975 · S/N 17264789 N61778Cambridge Valley Flying Club Inc · Shushan, NYBuilt 1975 · S/N 17264793 N6177EByrom Nathanto · Grass Valley, CAS/N 46277 N61780Delaney Kevin P · Germantown, TNBuilt 1975 · S/N 17264794 N61783Copper River Airmotive LLC · Copper Center, AKBuilt 1975 · S/N 17264797 N61785Fort Sam Houston Flying Club · San Antonio, TXBuilt 1975 · S/N 17264799 N61786Northwest Wings LLC · Hillsboro, ORBuilt 1975 · S/N 17264800 N61789Padilla Frank J · Vacaville, CAS/N 17264802 N6178EWaak Harlan L · Lincoln, NEBuilt 1958 · S/N 46278 N61794Dm Asset Management LLC · Plain City, OHBuilt 1975 · S/N 17264807 N61799Flf Aviation LLC · West Columbia, SCBuilt 1975 · S/N 17264810 N6179EHolland Frederic A · Advance, NCBuilt 1958 · S/N 46279 N6179RMcclinton Charles R · Cape Coral, FLBuilt 1979 · S/N 172RG0104 N617EPEpic Aviation Inc DBA · New Smyrna Beach, FLBuilt 2017 · S/N 172S12042 N617EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2021 · S/N 172S12717 N617FGRidgeline Assets LLC · Wilmington, DEBuilt 2020 · S/N 172S12597 N617SPPrecision Design Inc · Wilmington, DEBuilt 2000 · S/N 172S8606 N61801Tampa Aviation Club Inc · Tampa, FLBuilt 1975 · S/N 17264811 N61803N61803 LLC · Manassas, VABuilt 1975 · S/N 17264812 N61804Skyhawk Virginia LLC · Chester, VABuilt 1975 · S/N 17264813 N61808Cape Island Aviation LLC · Millville, NJBuilt 2008 · S/N 172S10709 N6180EUtica Township Vol Firefighter Assn Inc · Jeffersonville, INBuilt 1958 · S/N 46280 N6180TInternational Air Services Inc Trustee · Carson City, NVS/N 172S12389 N6180WChristiansen Aviation LLC · Wilmington, DEBuilt 2008 · S/N 172S10706 N6180XLewis University · Romeoville, ILBuilt 2008 · S/N 172S10707 N61812Craft Robert L · Cynthiana, KYBuilt 1975 · S/N 17264818 N61813Nationwide Aviation LLC · Hudson Oak, TXBuilt 1975 · S/N 17264819 N61814On Glideslope LLC · Middletown, DEBuilt 1975 · S/N 17264820 N61817Rb Aviation LLC · Vassar, MIBuilt 1975 · S/N 17264821 N6181FTarchinski James E · Rochester Hills, MIBuilt 1979 · S/N 17273161 N6181RTrahan Gregory M · Rayne, LABuilt 1979 · S/N 172RG0106 N61822Wings Over Texas Holdings LLC · Denton, TXBuilt 1975 · S/N 17264822 N61825Prestage Michael J · Hondo, TXBuilt 1975 · S/N 17264824 N61832Prop Wash Aero Inc · Senoia, GABuilt 1975 · S/N 17264828 N61834Offerman Leo · Emily, MNBuilt 1975 · S/N 17264829 N61835Epic Aviation Leasing LLC · Puyallup, WAS/N 17264830 N61837Park Richard J · Devol, OKBuilt 1975 · S/N 17264831 N61839Fixen Jimmie Trustee · Lynd, MNBuilt 1975 · S/N 17264833 N61840Jimenez Cruz Juan C · Mayaguez, PRS/N 17264834 N61841Burggraf Sean Hj · Grand Rapids, MNS/N 17264835 N61842Skywalker Flight Schoool LLC · Adrian, MIBuilt 1975 · S/N 17264836

Back to AD 90-06-03 R1