Registered aircraft · 26,230

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.

N1305QThomas George E · Marietta, OHBuilt 1971 · S/N 15072605 N1305YGraupmann John S · Arlington, WABuilt 1961 · S/N 17249005 N1306QCompton Kenneth Dale · Mebane, NCS/N 15072606 N1306YOklahoma Flight Academy LLC · Owasso, OKBuilt 1961 · S/N 17249006 N1307GPray Aviation Inc · Augusta, KSBuilt 1966 · S/N 17254120 N1307YOrange County Flight Center Inc · Santa Ana, CABuilt 1961 · S/N 17249007 N1308UCarson Danny L · Oneida, TNBuilt 1966 · S/N 15065444 N1308YBrewer Lester A · Magna, UTFirst renewal noticeS/N 17249008 N1309DOld Buzzard Aviation Inc · Middleburg, FLBuilt 1951 · S/N 19885 N1309HBrodie James W · Lind, WABuilt 1949 · S/N 15AC-340 N1309QSteenbarger Summer D · Woodland, WAS/N 15072609 N1309YC747 LLC · Wilmington, DEBuilt 1961 · S/N 17249009 N130AWMitchell Brent U · Shakopee, MNBuilt 2007 · S/N 601-045S N130RVUddin Nazim · Buffalo, NYS/N 15072090 N1310FHumphries Aviation LLC · Maysville, KYBuilt 1966 · S/N 17254805 N1311DAntkowiak Colton C · Chugiak, AKBuilt 1951 · S/N 19887 N1312FBill Stephan · Ellenville, NYBuilt 1966 · S/N 17254807 N1312YPierce Larry Jay · Brigham City, UTBuilt 1961 · S/N 17249012 N1313DPlowman Benjamin · Raleigh, NCBuilt 1951 · S/N 19889 N1313YSullivan Shawn M · The Dalles, ORBuilt 1962 · S/N 17249013 N13149Dughman Tim A · Willow, AKBuilt 1952 · S/N 19356 N1314BHildebrant Steven C · Newborn, GAFirst renewal noticeBuilt 1948 · S/N 5941 N1314FLee James Christopher · Concord, GABuilt 1966 · S/N 17254809 N1315FApsey Bradley D · Deckerville, MIBuilt 1966 · S/N 17254810 N1315QWhite Beth A · Keene, NHBuilt 1971 · S/N 15072615 N1316VKaufman Keith R · Reading, PABuilt 1947 · S/N 7BCM-446 N1317DBaer Monte Wayne · Ronan, MTS/N 19893 N1318DBott Christopher L · Pilot Point, TXFirst renewal noticeBuilt 1951 · S/N 19894 N1319QOutman Christopher · Lowell, MIBuilt 1971 · S/N 15072619 N1319YWinston William F · Lake Stevens, WABuilt 1961 · S/N 17249019 N131AWStanger Charles P · Yacolt, WABuilt 2007 · S/N 601-047S N131DHamilton Robert J · Perry, GABuilt 1967 · S/N 7887188 N131MTWings Over Texas Holdings LLC · Denton, TXBuilt 1973 · S/N 17262525 N131RHZollars Thomas Brooke · Dallas, TXS/N 1009-2007 N1320DHarlan Dale L · Big Lake, AKBuilt 1951 · S/N 19896 N1320HPoliti Terris P · Lake Placid, NYBuilt 1949 · S/N 15AC-354 N1320YStc Aviation Inc · Saint Cloud, MNBuilt 1962 · S/N 17249020 N13211Robinson Rick J · Rocky Mount, MOBuilt 1973 · S/N 17262577 N1321YDean Brandon Louis · Elm Mott, TXBuilt 1961 · S/N 17249021 N13221Cm3 LLC · North Las Vegas, NVBuilt 1973 · S/N 17262586 N1322HSynnes Greggory M · Killdeer, NDBuilt 1949 · S/N 15AC-356 N1322QMadden Killian · Worcester, MABuilt 1971 · S/N 15072622 N1323HMcginnis John W · Strawberry Plains, TNBuilt 1948 · S/N 15AC-357 N1324FWyllie Ashton R J Trustee · Thornton, NHBuilt 1966 · S/N 17254819 N1324HHudson Aircraft Service · Tallahassee, FLBuilt 1949 · S/N 15AC-359 N1324YRuoff Timothy D · Topeka, KSBuilt 1961 · S/N 17249024 N1325NLovingier Michael J · Locust Grove, VABuilt 1951 · S/N 1 N1326FRegistration Pending · Heber Springs, ARRegistration pendingBuilt 1966 · S/N 17254821 N1326QFreburg Larry D · Omaha, NEBuilt 1971 · S/N 15072626 N1326YPine Barbara J · Tok, AKBuilt 1961 · S/N 17249026

Back to AD 94-05-05 R1