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.

N191CACsa Aircraft Leasing LLC · Salt Lake City, UTS/N 17281243 N191SHHutton Stephen · Madison, MSBuilt 1968 · S/N 17257232 N191WWLichtscheidl Ted J · Forest Lake, MNBuilt 1972 · S/N 17260840 N1920FChristensen Dean G · Elk Grove, CABuilt 1979 · S/N 17273012 N1921FState Of Iowa · Iowa City, IABuilt 1979 · S/N 17273013 N1922SRodland Roy A · Monroe, WAS/N 17251523 N1922VRogers Randall J · Newalla, OKBuilt 1974 · S/N 17263796 N1923FAtlanta Air Academy LLC · Kennesaw, GABuilt 1980 · S/N 17273015 N1926FUnited Flying Club Inc · Belmont, CABuilt 1979 · S/N 17273017 N1926REmbry Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2025 · S/N 172S13436 N1927FSanders Herman G · Baldwyn, MSBuilt 1979 · S/N 17273018 N1928FJav Air Services LLC · Anchorage, AKBuilt 1979 · S/N 17273019 N192ARDj Whelan Corp · Sag Harbor, NYBuilt 1978 · S/N 17272016 N192DKLong Drive Holdings LLC · Alpine, UTS/N 17265020 N192JPBoard Of Trustees Of Southern Illinois University · Murphysboro, ILBuilt 2005 · S/N 172S9894 N192MCWarrington Flying Club Inc · Doylestown, PABuilt 2006 · S/N 172S10162 N192MEKindrick Jan W · Mt Vernon, TXBuilt 2000 · S/N 172S8454 N1930VDodson International Parts Inc · Rantoul, KSFirst renewal noticeBuilt 1974 · S/N 17263798 N1931HMountain Air Aviation LLC · Fruit Heights, UTBuilt 2006 · S/N 172S10128 N1931VRegistered aircraftBuilt 1974 · S/N 17263799 N1933FVidal Aviation LLC · Gaithersburg, MDBuilt 1979 · S/N 17273023 N1934GAero-Tech Services Inc · Lititz, PABuilt 2006 · S/N 172S10129 N19369Aci Aviation LLC · Costa Mesa, CABuilt 2006 · S/N 172S10130 N1936FCheek David H · Garland, TXBuilt 1979 · S/N 17273026 N19370Clanton Ronald W · Aurora, COBuilt 1968 · S/N 17257181 N1937FA2 Flight Leasing LLC · Castro Valley, CABuilt 1979 · S/N 17273027 N1939SFallon Timothy · Center Barnstead, NHBuilt 2005 · S/N 172S9974 N193JSRyan Moore LLC · Fayetteville, NCBuilt 1975 · S/N 17265118 N193MEHorizon Flight Center LLC · Chesapeake, VABuilt 2000 · S/N 172S8458 N193SPIndiana State Police · Greenwood, INS/N 172-76346 N193THWingsleasing LLC · Wichita, KSBuilt 2015 · S/N 172S11551 N1940FAmerican Asset Leasing LLC · Livermore, CAS/N 17273030 N1945FLake Elmo Aero LLC · Lake Elmo, MNBuilt 1979 · S/N 17273035 N1947FMelbourne Flight Training LLC · Melbourne, FLBuilt 1979 · S/N 17273037 N1947LCal Aggie Flying Farmers · Davis, CABuilt 2016 · S/N 172S11765 N1948FKdrd Holdings LLC · Texas City, TXBuilt 1979 · S/N 17273038 N1949PEast Bay Trading Co LLC · Fairview, PABuilt 1973 · S/N 17262835 N194ARTarpley Richard · Cleveland, GABuilt 1978 · S/N 17272029 N194SESamnik Enterprises LLC · Naples, MEBuilt 1972 · S/N 17260386 N194SPFly4sp LLC · San Mateo, CABuilt 2003 · S/N 172S9459 N194THWingsleasing LLC · Wichita, KSBuilt 2015 · S/N 172S11552 N1950FAce Of Spades Aviation LLC · Las Vegas, NVS/N 17273040 N1954VBray Aviation LLC · Calera, OKBuilt 1974 · S/N 17263803 N1955VJd Kracl Aircraft LLC · Gretna, NEBuilt 1974 · S/N 17263804 N1956FPenzo Michael A · Stafford, VABuilt 1979 · S/N 17273046 N1956VMedary Aviation LLC · Brookings, SDBuilt 2005 · S/N 172S9934 N1957Registered aircraftBuilt 1977 · S/N 17269009 N1957FSteward Ashtyn L · Weatherford, TXBuilt 1979 · S/N 17273047 N1957WDye Roger C · Pomeroy, WAS/N 36045 N1958BSale Reported · Champaign, ILSale reportedBuilt 1973 · S/N 17261839

Back to AD 90-06-03 R1