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.

N8310XBarah Inc · Wilmington, DEBuilt 1961 · S/N 17248810 N8311BSills Joseph G · Giddings, TXBuilt 1957 · S/N 36111 N8311UVendetta Consulting LLC · Bellevue, NEBuilt 1964 · S/N 17252211 N8312BCheatham Harold Joseph · San Diego, CARegistration revokedBuilt 1957 · S/N 36112 N8312URowe John R · Stevens Point, WIBuilt 1964 · S/N 17252212 N8312XPangerl Gary D · Mara, MNBuilt 1961 · S/N 17248812 N8313XJones Brian R · Turlock, CABuilt 1961 · S/N 17248813 N8314USchmidt Roger W · Wood River, NEBuilt 1964 · S/N 17252214 N8314XEramo Jennilee · Fayetteville, NCBuilt 1961 · S/N 17248814 N8315XRozhon Richard J · Valparaiso, INBuilt 1961 · S/N 17248815 N8316BHudspeth Steve A · Wasilla, AKBuilt 1957 · S/N 36116 N8316LCorletto Carlos · Bermuda Dunes, CABuilt 1968 · S/N 17256516 N8317GEagle Simulator LLC · Lake Oswego, ORS/N 17273620 N8317LWalker Paul R · Ursa, ILBuilt 1968 · S/N 17256517 N8317URiver International LLC · Orlando, FLS/N 17252217 N8317XLittle Air Dream LLC · Mooresville, NCBuilt 1961 · S/N 17248817 N8318BRegistration Pending · Redondo Beach, CARegistration pendingBuilt 1957 · S/N 36118 N8318EJust Planes Inc · Hobbs, NMFirst renewal noticeS/N 17272187 N8318UBeattie Steven K · Colville, WABuilt 1964 · S/N 17252218 N8319BLobue Andrew N · Gresham, ORBuilt 1957 · S/N 36119 N8319LLaudon Piper C · Anchorage, AKS/N 17256519 N831AFAmeriflyers Of Texas Inc · Addison, TXBuilt 2026 · S/N 172S13531 N831BRAir Future Airways Corp · Miami, FLBuilt 1998 · S/N 172S8044 N831EREmbry Riddle Aeronautical University · Daytona Beach, FLBuilt 2022 · S/N 172S12842 N831KXRkm Leasing LLC · Greenwich, CTBuilt 2011 · S/N 172S11107 N831MAState Of Wisconsin · Madison, WIBuilt 2001 · S/N 172S9003 N831VZMelbourne Flight Training LLC · Melbourne, FLBuilt 1985 · S/N 17276416 N8320XHagovsky Thomas C · Attica, INBuilt 1961 · S/N 17248820 N8321BSkyhawk18 LLC · Opa Locka, FLBuilt 1957 · S/N 36121 N8321UBoss Bradley J · Clarksville, TNBuilt 1964 · S/N 17252221 N8322UBurkett Kevin H · Portland, TXBuilt 1964 · S/N 17252222 N8323UFortman Steven W · Minneapolis, MNBuilt 1964 · S/N 17252223 N8323XHumpage Jason H · Eugene, ORBuilt 1961 · S/N 17248823 N8324BVitt Steven · Lecanto, FLBuilt 1957 · S/N 36124 N8324EGc Aviation Services-1 LLC · Miamisburg, OHBuilt 1979 · S/N 17272189 N8324XJohnson Scott A · Missoula, MTBuilt 1961 · S/N 17248824 N8325BDeckard Leroy Jr · Waller, TXS/N 36125 N8325UCross Dustin · Tonto Basin, AZBuilt 1964 · S/N 17252225 N8326XFlores Thomas E · Balch Springs, TXS/N 17248826 N8327XTwo Seven Xray LLC · Paradise Valley, AZS/N 17248827 N8328BMontpelier Gary L · W Chazy, NYBuilt 1957 · S/N 36128 N8328XPrevatt Richard T · Jacksonville, FLBuilt 1961 · S/N 17248828 N8329UVolkman Ary D · Waunakee, WIS/N 17252229 N832DCCase Daniel J · Spokane, WABuilt 1979 · S/N 17271180 N832EREmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 2021 · S/N 172S12669 N832KXHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2011 · S/N 172S11109 N832MAState Of Wisconsin · Madison, WIBuilt 2001 · S/N 172S9004 N8331LMjl Investment Company Inc · Branchville, NJBuilt 1968 · S/N 17256531 N8332UNeeley James L · Temecula, CABuilt 1964 · S/N 17252232 N8332XFlight Instruction Inc · Central City, NEBuilt 1961 · S/N 17248832

Back to AD 90-06-03 R1