OpenAirDocs.org
AD 94-18-04 R1

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

N870DFHall William R · Franklin, NCBuilt 1946 · S/N 870N87100Mcnew Stephen J · Brookville, OHBuilt 1946 · S/N 273N87101Courser Jacob A · West Hartford, CTBuilt 1946 · S/N 274N87103Gregory Vernon L · Swansea, SCBuilt 1946 · S/N 276N87104Jp Flying LLC · Dover, DEBuilt 1946 · S/N 277N87115Priesmeyer Arthur J · El Campo, TXBuilt 1946 · S/N 288N87118Wittco Aero LLC · Vancouver, WABuilt 1946 · S/N 291N87121Clark Charles A · Fitzgerald, GABuilt 1946 · S/N 294N87124Kadel James R · Portsmouth, OHBuilt 1946 · S/N 297N87133Todd W Wish · Sellersville, PABuilt 1946 · S/N 306N87155Purnell James I · Manassas, VAFirst renewal noticeBuilt 1946 · S/N 328N87161Carlberg Brad S · Hoodsport, WABuilt 1946 · S/N 334N87162Evans Orville J · New Philadelphia, OHBuilt 1946 · S/N 335N87170Withrow Thomas E · Lewisburg, WVS/N 343N87171Toth Richard J · Windber, PABuilt 1946 · S/N 344N87187Fountain Robert A · Suitland, MDBuilt 1946 · S/N 360N87197Craparo John S · Georgetown, TXS/N 370N87198Rogers Samuel · Le Roy, KSBuilt 1946 · S/N 371N87201Yurasich Tom J · Sedalia, MOBuilt 1946 · S/N 374N87206Colangione Anthony P · Troy, NYBuilt 1946 · S/N 379N87213Meyer Theodore J · Conway Springs, KSBuilt 1946 · S/N 386N87215Orr Leroy A · Tonasket, WAS/N 388N87223Ballew James W · Collinsville, OKBuilt 1946 · S/N 396N87231Bayne William R · Kaufman, TXFirst renewal noticeS/N 404N87240Hacker James D · Borden, INBuilt 1946 · S/N 413N87248Biggs William E · Temple, TXBuilt 1946 · S/N 421N87264Homic Michael J · Edmond, OKBuilt 1946 · S/N 437N87267Collins Dennis L · Richland, WABuilt 1946 · S/N 440N87274Webb Aaron J · Monroe, GABuilt 1946 · S/N 447N87277Webb Patrick S · Chuckey, TNBuilt 1946 · S/N 450N87281Faulds Chad A · Mount Pleasant, WIBuilt 1946 · S/N 454N87283Hornby Larry E · Helena, MTBuilt 1946 · S/N 456N87286Eaa Chapter 1590 Inc · Morrilton, ARBuilt 1946 · S/N 459N87289Hamlin Timothy S · Bunker Hill, KSS/N 462N87296Brigitte Krivan Iris · Port Saint Lucie, FLBuilt 1946 · S/N 469N87299Registration Pending · Sacramento, CARegistration pending, pending cancellationS/N 472N872BWMosman Thomas M · Kingsland, TXBuilt 1946 · S/N 443N87304Mackie Kevin S · Longview, WABuilt 1946 · S/N 477N87312Lademann Ryan C · Saint Clair Shores, MIBuilt 1946 · S/N 485N87315Lucarelli David L · Moncks Corner, SCBuilt 1946 · S/N 488N87321Wiger Theodore L · Falcon Heights, MNS/N 494N87326Dixon Richard L · Owensboro, KYBuilt 1946 · S/N 499N87329Fleming Michael A · Palm Bay, FLS/N 502N87330Maison Taisiya E · Olney, MDBuilt 1946 · S/N 503N87333Luft Aviation Inc · Wilmington, DEBuilt 1946 · S/N 506N87335Thomas Stewart L · Watkinsville, GABuilt 1946 · S/N 508N87336Abreu David A · Del Rio, TXBuilt 1946 · S/N 509N87340Eleazer Robert W III · Merritt Island, FLBuilt 1946 · S/N 513N87344Luft Aviation Inc · Wilmington, DEBuilt 1946 · S/N 517N87348Howard Dale L · Harrisburg, NCBuilt 1946 · S/N 521
Back to AD 94-18-04 R1