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.

N8133BReaka Dean James Trustee · Troy, MOBuilt 1957 · S/N 29933 N8133XAdamie Isaac Sloan · Bowling Green, KYBuilt 1961 · S/N 17248633 N8134BTreefo Bravo LLC · Hawkins, TXS/N 29934 N8134UColey Lee · Fayetteville, GABuilt 1964 · S/N 17252034 N8134XLugas Grant A · Elyria, OHBuilt 1961 · S/N 17248634 N8135XMatarelli Robert E Jr · Carlton, MNBuilt 1961 · S/N 17248635 N8136BStanley Mark E · Paso Robles, CABuilt 1957 · S/N 29936 N8136UMoors Thomas G · Wentzville, MOBuilt 1964 · S/N 17252036 N8136XStevenson George Otis · Wheatland, WYBuilt 1961 · S/N 17248636 N8137BKelly James E · Accord, NYBuilt 1957 · S/N 29937 N8137XHarritt Roger · Anchorage, AKBuilt 1961 · S/N 17248637 N8138XHarris David L · Wichita, KSFirst renewal noticeBuilt 1961 · S/N 17248638 N8139BDavies Lincoln J · Oostburg, WIBuilt 1957 · S/N 29939 N8139XMerkle Patrick G · Washington, DCBuilt 1961 · S/N 17248639 N813CAChristiansen Aviation LLC · Wilmington, DEBuilt 2025 · S/N 172S13362 N813EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2022 · S/N 172S12818 N813GFChristiansen Aviation LLC · Wilmington, DEBuilt 2011 · S/N 17281588 N813HYOcala Aviation Services Inc · Ocala, FLBuilt 1964 · S/N 17252033 N813KSFargo Jet Center LLC · Fargo, NDBuilt 2005 · S/N 17281247 N8140BOlson Larry G · Walnut Creek, CABuilt 1957 · S/N 29940 N8140UAnderson Milton M · Twin Bridges, MTS/N 17252040 N8140XHubbell Carl · Crowley, TXBuilt 1961 · S/N 17248640 N81424Wbair LLC · Wills Point, TXS/N 17256218 N8142BJones Ronald E · Cromwell, CTBuilt 1957 · S/N 29942 N8142UMartin Ralph Edward · Jonesboro, ARBuilt 1964 · S/N 17252042 N8142XWhitehead Daniel · New Providence, IABuilt 1961 · S/N 17248642 N8143UJon Boyd Beard · Houston, TXBuilt 1964 · S/N 17252043 N8144BPepper Marcus · San Antonio, TXBuilt 1957 · S/N 29944 N8144XBeadles Scott D · Valley Springs, CABuilt 1961 · S/N 17248644 N8145BRojas Luis Alberto · Riverside, CABuilt 1957 · S/N 29945 N8145XEast Carolina Aviation LLC · Camden, NCBuilt 1961 · S/N 17248645 N8146UBearce Todd A · Phoenix, AZS/N 17252046 N8148BRoberts Michael · Port Orchard, WABuilt 1957 · S/N 29948 N8149BBergstrom Matthew James · Renton, WABuilt 1957 · S/N 29949 N8149XBlacksword Armoury Inc · Hawthorne, FLBuilt 1961 · S/N 17248649 N814BMMcdaniel Robert L · Columbia, ILBuilt 1966 · S/N 17255216 N814CAChristiansen Aviation LLC · Wilmington, DEBuilt 2025 · S/N 172S13364 N814DEDickinson Dennis D · St Pete Beach, FLBuilt 1966 · S/N 17254192 N814EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2024 · S/N 172S13184 N814FGRidgeline Assets LLC · Wilmington, DEBuilt 2020 · S/N 172S12456 N814HAIasco Flight Training Inc · Redding, CABuilt 1999 · S/N 17280814 N814KSFargo Jet Center LLC · Fargo, NDBuilt 2005 · S/N 17281248 N814MVSterling Flight Training LLC · Jacksonville, FLBuilt 2005 · S/N 172S9965 N814RReed Mackenzie · Princeton, TXS/N 17260405 N814SAMarion Military Institute · Marion, ALBuilt 2002 · S/N 17281114 N8150BFond Of Flying Co · Dover, DES/N 29950 N8150LKal Aero Flight Instruction LLC · Mattawan, MIBuilt 1967 · S/N 17256350 N8151BBig Valley Flying Club · Lookout, CABuilt 1957 · S/N 29951 N8151LBrown Gary D · Rainbow City, ALBuilt 1967 · S/N 17256351 N8151UYork George T · Harvard, ILBuilt 1964 · S/N 17252051

Back to AD 90-06-03 R1