Skip to content

Registered aircraft · 1,310

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:94-18-04-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:94-18-04-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:94-18-04-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:94-18-04-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:94-18-04-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:94-18-04-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.

N5664FGiszterowicz Krzysztof · El Cerrito, CAS/N A164 N5669FEggers Michael Ryal · Colorado Springs, COBuilt 1966 · S/N A-169 N5670FSayles Curtis E · Seibert, COS/N A-170 N5672FBaker Donald N · Starkville, MSBuilt 1966 · S/N A-172 N5674FGregory Vernon L · Swansea, SCBuilt 1966 · S/N A-174 N5675FSpurlock Bill C · Elk City, OKBuilt 1966 · S/N A-175 N5676FBrad S Jones LLC · Oak Hill, FLBuilt 1966 · S/N A-176 N5677FFarmer Jim D · Savannah, MOBuilt 1966 · S/N A-177 N5678FGregory Vernon L · Swansea, SCBuilt 1966 · S/N A-178 N5679FLong Mark B · Wichita, KSBuilt 1966 · S/N A-179 N5683FBrady Robert M · Shawnee, KSS/N A-183 N5684FRegistered aircraftBuilt 1966 · S/N A-184 N5685FRailton Joseph · Wadesboro, NCBuilt 1966 · S/N A-185 N5686FElling Jerrold A · Ladysmith, WIBuilt 1966 · S/N A-186 N5689FCarrell William G · Pittsburgh, PABuilt 1966 · S/N A-189 N5691FBahm Martin P · Edmond, OKBuilt 1966 · S/N A-191 N5692FSchneider Scott M · Tribune, KSBuilt 1966 · S/N A-192 N5694FAmerican Airpower Heritage Flying Museum · Dallas, TXBuilt 1966 · S/N A-194 N5695FTiger Flight Foundation Inc · Rome, GABuilt 1966 · S/N A-195 N5697FWilson Myron L · Cut Bank, MTBuilt 1966 · S/N A-197 N5698FGriggs Joseph L · Murphy, NCBuilt 1966 · S/N A-198 N5699FGriggs Joseph L · Murphy, NCBuilt 1966 · S/N A-199 N56JBWalker Mark C · New Castle, VABuilt 1946 · S/N 1062 N57QMowad John · El Paso, TXBuilt 1961 · S/N 5745 N5830MTotten Matthew W · Wamego, KSS/N 2161 N5918FGregory Vernon L · Swansea, SCS/N A-213 N611GCIppolito Joseph · Fremont, CAS/N 611 N611PColton Richard F · Grants Pass, ORS/N 5075 N6132CSnodgrass James T · Gallipolis, OHBuilt 1956 · S/N 5606 N6136CRegan Corey J · Tehachapi, CABuilt 1956 · S/N 5607 N6139CDaughters Turpen A · Sun City, AZBuilt 1957 · S/N 5608 N6204YHinnen Michael L · Toronto, KSBuilt 1946 · S/N 3771 N6353VDutch Ladybird LLC · Mayville, WIBuilt 1965 · S/N A-29 N6354VAdvanced Aircrew Training LLC · Nashua, NHBuilt 1965 · S/N A-30 N6355VNelson Lynn H · Frostproof, FLBuilt 1965 · S/N A-31 N6357VSelf Robert B · Blanchard, OKBuilt 1965 · S/N A-33 N6358VBurleson James R · Snyder, TXBuilt 1965 · S/N A-34 N6360VKato Matt J · Fairbanks, AKBuilt 1965 · S/N A-36 N6361VMcgowan Tim · Calhoun, GABuilt 1965 · S/N A-37 N6362VCarver Norman C · Gilbert, AZBuilt 1965 · S/N A-38 N6363VGregory Vernon L · Swansea, SCBuilt 1965 · S/N A-39 N6364VGregory Vernon L · Swansea, SCBuilt 1965 · S/N A-40 N6365VHoskins Marc R · Kennett, MOS/N A-41 N6366VCombs Ronnie M · Albany, MOBuilt 1965 · S/N A-42 N6370VWhite Berry · Runaway Bay, TXBuilt 1965 · S/N A-46 N6372VWhitcomb Keith R · Villa Rica, GABuilt 1965 · S/N A-48 N6373VKaichen Michael Trustee · Eliot, MEBuilt 1965 · S/N A-49 N6375VBarker Benjamin J · Pittsburg, NHBuilt 1965 · S/N A-51 N6500QGartland John J · Brooklyn Park, MNBuilt 1966 · S/N A-100 N6503QRathmann Arnold H · Hoffman Estates, ILBuilt 1966 · S/N A-103

Back to AD 94-18-04 R1