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.

N8108XReding Joel M · Whittemore, IABuilt 1961 · S/N 17248608 N8109LVajgrt Richard Eugene · Mobile, ALBuilt 1967 · S/N 17256309 N810CAChristiansen Aviation LLC · Wilmington, DEBuilt 2025 · S/N 172S13358 N810CLMathews Roy E · Sparta, MIBuilt 1970 · S/N 17259162 N810EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2026 · S/N 172S13508 N810FSModi Yogini · Homestead, FLBuilt 1979 · S/N 17272297 N810JLFly Cessna LLC · Peoria, AZBuilt 1981 · S/N 17274975 N810KKKenzy 2023 LLC · Aurora, ORBuilt 2023 · S/N 172S13060 N810KSFargo Jet Center LLC · Fargo, NDBuilt 2005 · S/N 17281244 N810SABlack Hound Aviation LLC · Austin, TXBuilt 2003 · S/N 172S9422 N810SUApm Leasing LLC · Casper, WYBuilt 1979 · S/N 17272319 N8110LMiller Brian T · Savage, MNBuilt 1967 · S/N 17256310 N8110UHeigle Randall K · Fouke, ARBuilt 1964 · S/N 17252010 N8111BTaylor Brad · Alma, GABuilt 1957 · S/N 29911 N8111UTarkki Jarmo O · Solvang, CABuilt 1964 · S/N 17252011 N8111XPhillips Zachary T · Kettering, OHBuilt 1961 · S/N 17248611 N8112UHaleco LLC · Pensacola, FLBuilt 1964 · S/N 17252012 N8112XPeterson Michael D · New Richmond, WIBuilt 1961 · S/N 17248612 N8113LN8113l LLC · Auburn, INBuilt 1967 · S/N 17256313 N8114BAllan Bryan S · Sandy Valley, NVBuilt 1957 · S/N 29914 N8118BBarrera Daniel J · Sugar Land, TXS/N 29918 N8118URegistration Pending · Heath, OHRegistration pendingBuilt 1964 · S/N 17252018 N811BJSix Pack Aviation LLC · Pocono Pines, PABuilt 1979 · S/N 17272287 N811CAChristiansen Aviation LLC · Wilmington, DEBuilt 2025 · S/N 172S13359 N811CTBravo Aircraft LLC · Ooltewah, TNBuilt 2020 · S/N 172S12492 N811EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2023 · S/N 172S12958 N811JDSanders Jason C · Babylon, NYBuilt 1975 · S/N 17265353 N811KSFargo Jet Center LLC · Fargo, NDBuilt 2005 · S/N 17281245 N811LTegtmeier Michael C · Watertown, WIBuilt 1956 · S/N 29014 N8121UFishburn Tol M · Eagle River, AKBuilt 1964 · S/N 17252021 N8122XRusty Flyer Aviation LLC · Grove City, OHBuilt 1961 · S/N 17248622 N8123BVan Maren John C · Owasso, OKBuilt 1957 · S/N 29923 N8124BVan Skyhawk Charles R · Eagle River, WIS/N 29924 N8124UGardoski Mark · Twin Falls, IDBuilt 1964 · S/N 17252024 N8124XNehrbass Douglas · Clarksville, TNBuilt 1961 · S/N 17248624 N8125BTrue Heading LLC · Granite City, ILBuilt 1957 · S/N 29925 N8125UAgati Stephen B · Tucker, GABuilt 1964 · S/N 17252025 N8125XBlue Skies Flying Services LLC · Blandon, PAS/N 17248625 N8126BRobinson Michael E · Anthony, NMBuilt 1957 · S/N 29926 N8126EAnderson Wilbur W Trustee · Lead Hill, ARBuilt 1978 · S/N 17272143 N8127XBlick Clayton T · Dunedin, FLBuilt 1961 · S/N 17248627 N8128UWalters Stephen B · Madison, ALBuilt 1964 · S/N 17252028 N8129BSeneca Enhancements Company LLC · Portland, ORBuilt 1957 · S/N 29929 N812CPHigh Wing Air Services LLC · Merritt Island, FLBuilt 1977 · S/N 17268790 N812DAHanson Aviation LLC · Winter Park, FLBuilt 1979 · S/N 17273577 N812EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2022 · S/N 172S12797 N812KSUniversity Of Central Missouri · Warrensburg, MOBuilt 2005 · S/N 17281246 N8130BJohnson Daniel P · Pardeeville, WIBuilt 1957 · S/N 29930 N8130UWade Air LLC · Clanton, ALBuilt 1964 · S/N 17252030 N8131UTodd James M · Angleton, TXBuilt 1964 · S/N 17252031

Back to AD 90-06-03 R1