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.

N20876Ogalalla Land & Cattle Ltd · Douglas, WYS/N 17263863 N2087EPcs Aviation LLC · La Canada, CABuilt 1978 · S/N 17271150 N2087YEllsworth Matthew R · Fairbanks, AKBuilt 1963 · S/N 17249587 N20884Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12581 N2088YHowell Rebecca Elizabeth · Elgin, TXBuilt 1962 · S/N 17249588 N20891Morristown Flying Service Inc · Talbott, TNBuilt 1974 · S/N 17263867 N2089ESkyhawk N2089e Ltd · Deerfield, ILBuilt 1978 · S/N 17271151 N2089YSooter Craig A · Sedgwick, KSBuilt 1962 · S/N 17249589 N208ATLeciejewski Darrell K · Mc Alpin, FLBuilt 1976 · S/N 17268379 N208CPChristiansen Aviation LLC · Wilmington, DEBuilt 2020 · S/N 172S12502 N20910Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12582 N20913Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12583 N2091YCut And Snip Flyers LLC · South Weber, UTBuilt 1962 · S/N 17249591 N20921Brigham David F · Elliottsville Twp, MEBuilt 1974 · S/N 17263869 N2092YNiver Michael A · Plymouth, WIBuilt 1962 · S/N 17249592 N20932Registration Pending · Hammond, LARegistration pendingBuilt 1974 · S/N 17263872 N20934Fly Skyhawk Llp · Galena, OHBuilt 1974 · S/N 17263874 N2093YSale Reported · Agar, SDSale reportedBuilt 1962 · S/N 17249593 N20940Cirrus Flight Operations Inc · Minneapolis, MNBuilt 1974 · S/N 17263876 N2094YHill Karl A · Visalia, CABuilt 1963 · S/N 17249594 N20951Strevels Stephen M · Knoxville, TNBuilt 1974 · S/N 17263879 N20954Hardin John M · Terrell, TXS/N 17263881 N20957Mustang Sally Aviation LLC · Camden, SCBuilt 2004 · S/N 172S9571 N2095YJurca John · Punta Gorda, FLBuilt 1962 · S/N 17249595 N20965Reich Aviation LLC · Loudon, TNBuilt 1974 · S/N 17263883 N2097GMountain Air Aviation LLC · Fruit Heights, UTBuilt 2004 · S/N 172S9662 N2097TPatriot Aviation Inc · Greenville, DEBuilt 2004 · S/N 172S9585 N2097YWulff Jonathan P · Eaton Rapids, MIBuilt 1962 · S/N 17249597 N2098AAtp Aircraft 1 LLC · Wilmington, DEBuilt 1999 · S/N 17280762 N2098YLevel Altitude LLC · Seward, NEBuilt 1962 · S/N 17249598 N20997Aerowood Aviation LLC · Monroe, NCBuilt 1964 · S/N 17251217 N2099DRollins Dale G · Covington, LABuilt 2004 · S/N 17281204 N209DPBke Air LLC · Newnan, GABuilt 1977 · S/N 17270158 N209HVAnderson Scott · Salem, ORBuilt 1979 · S/N 17272302 N209JSCrystal Coast Training LLC · Kinston, NCBuilt 2023 · S/N 172S13008 N209KFf22 LLC · Scottsdale, AZBuilt 2022 · S/N 172S12826 N209LJCat Agri Aviation Inc · Walnut Ridge, ARS/N 36334 N20AAGrand River Aviation LLC · Kremmling, COBuilt 1968 · S/N 17256596 N20BQAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13216 N20CUCosta Flying Service Inc · Painted Post, NYBuilt 1980 · S/N 172RG0323 N20DKFlight Surgeon LLC · Fayetteville, ARBuilt 1976 · S/N 17266836 N20EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2020 · S/N 172S12513 N20HTRed Arrow Aviation LLC · Santa Teresa, NMBuilt 1969 · S/N 17258306 N20MUOracle Aviation LLC · Omaha, NEBuilt 1978 · S/N 17271496 N20MVElizabeth City State University · Elizabeth City, NCBuilt 2018 · S/N 172S12143 N20RHStoltzfus John F Jr · Strasburg, PAS/N 172-68331 N20SUOhio State University · Columbus, OHBuilt 2015 · S/N 172S11623 N20WMMcdonald John P · Kennewick, WAFirst renewal noticeBuilt 1973 · S/N 17261658 N2100SBietsch Aviation LLC · Dumfries, VABuilt 2004 · S/N 172S9589 N21015Renfro Michael W · Bethel, AKBuilt 1974 · S/N 17263888

Back to AD 90-06-03 R1