Skip to content

Registered aircraft · 26,231

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-05-05-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-05-05-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-05-05-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-05-05-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-05-05-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-05-05-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.

N4769XAnderson Aviation LLC · Erie, PABuilt 1966 · S/N 15064819 N476DTTallarita Domenic A · Palm Springs, CAS/N 17254299 N476MSBrooks Duane T Trustee · Mount Shasta, CAS/N 15077515 N4771HKeogh Lynn H · Wasilla, AKS/N 11-703 N4773XBlack Diamond Aviation LLC · Rathdrum, IDBuilt 1967 · S/N 15064823 N4776HNorman Douglas M · Cut Bank, MTBuilt 1948 · S/N 11-706 N4776XMersiowsky Richard R · King George, VABuilt 1966 · S/N 15064826 N47793Taylor Jimmie D · Hedley, TXBuilt 1965 · S/N 15061406 N4779HSalant Evan P · Brooklyn, NYBuilt 1948 · S/N 11-725 N4779XSnodgrass James T · Gallipolis, OHBuilt 1966 · S/N 15064829 N4780XBroyles Dean L · Pittsboro, INBuilt 1966 · S/N 15064830 N4781XMartinez Ivan A · Oro Valley, AZBuilt 1966 · S/N 15064831 N4782MWellborn Ralph L · Kenai, AKBuilt 1947 · S/N 11-297 N4784XOgletree Ben R Jr · Livingston, TXBuilt 1966 · S/N 15064834 N4789MCrawford Alan R · Buchanan Dam, TXBuilt 1947 · S/N 11-303 N4789XGrald Jonathan A · Goshen, NYFirst renewal noticeBuilt 1966 · S/N 15064839 N478EZIrvin Bradley A · Lula, GAFirst renewal noticeBuilt 1979 · S/N 1314 N4791MPatrick Hallett · Anchorage, AKBuilt 1947 · S/N 11-305 N4791XBowden Wyatt D · Hamburg, ARBuilt 1966 · S/N 15064841 N4794HHeyano Robert G · Dillingham, AKBuilt 1946 · S/N 11-761 N4795HGallion David B · Michigan City, INBuilt 1948 · S/N 11-766 N4795XHopkins Eric J · Wasilla, AKBuilt 1966 · S/N 15064845 N4796H170 Bowen Brothers LLC · Post Falls, IDBuilt 1946 · S/N 11-765 N4797XChadwell Letch J · Hulbert, OKBuilt 1966 · S/N 15064847 N4798HWells Kris G · Barron, WIBuilt 1948 · S/N 11-768 N4799XBee Air LLC · Evansville, INBuilt 1966 · S/N 15064849 N479EMatcho Jonathan M · Martinsville, NJBuilt 1995 · S/N 2080 N47DPMoler Alan D · Valley Center, KSBuilt 1946 · S/N 7AC-5722 N47FVVyfvinkel Frederick J · New Smyrna Beach, FLBuilt 1947 · S/N 5504 N47GDGreen Seth M · Brandon, FLBuilt 1994 · S/N 005 N47JCCasey Michael T · Soddy Daisy, TNBuilt 2009 · S/N CC11-00112 N47JHDavies Nathan C · Columbus, MSBuilt 1989 · S/N 9811 N47KPierce Terence M · Mojave, CABuilt 1954 · S/N FS-1 N47KVCaron Robert M · Vero Beach, FLBuilt 1959 · S/N 56239 N47LCBell Aviation LLC · Fort Payne, ALBuilt 2011 · S/N AL-1163 N47PFour Seasons Aviation Inc · Albuquerque, NMBuilt 1977 · S/N 15079224 N47VESchababerle Mark Joseph · Cincinnati, OHBuilt 2005 · S/N 726 N47WRRobillard Robert P · Lewis Center, OHBuilt 1946 · S/N 8454 N4800XHoistad Rick Allen · Forman, NDS/N 15064850 N4807XHile Daniel A · Clearfield, PABuilt 1966 · S/N 15064857 N4809XKc Aviation LLC · Kalispell, MTBuilt 1966 · S/N 15064859 N480KSSheely Kevin J · West Palm Beach, FLBuilt 2014 · S/N 2921 N4811FHurlston Glenn D · Leesville, LABuilt 1973 · S/N A1500417 N4811MSchumacher Marvin L · Pierre, SDBuilt 1947 · S/N 11-322 N4811PPolsfut Todd L · Bakersfield, CABuilt 1947 · S/N 11866 N48120Trzcinski Douglas R · Chesapeake, VABuilt 1948 · S/N 14339 N4812MBristow Michael K · Smyrna, GABuilt 1947 · S/N 11-323 N4816HBressler John P · Duncannon, PABuilt 1948 · S/N 17-114 N4818HEiden Ryan J · Central, AKS/N 17-116 N4818MWolery Chet · Chester, MTBuilt 1947 · S/N 11-329

Back to AD 94-05-05 R1