AD 94-05-05 R1
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
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.
N3119AMouw Trea C · Chino, CAN3119JBerthelsen Mark A · Baker City, ORN311BKFlattum Steven II · Algonquin, ILN311CMBlood Peter L · Spokane, WAN311EPPrice Keri-Ann · Rockmart, GAN311MTTowey Martin J · Sanger, TXN311SGRapattoni Ryan · Los Angeles, CAN31207Innes William J · Oroville, WAN31209Hockenson Roy D · Auburn, WAN3120BRustad Scott K · Minot, NDN3120NDahlke Philip H · Smyrna, GAN3121HArnold Thomas J · Hooker, OKN3122AJohns William D · Lodi, CAN3122JMulvihill Murphy A · Northbrook, ILN3123VColemaker Aero & Marine LLC · Saint Augustine, FLN3123XRegistered aircraftN3124AWolstenholme Robert · Line Lexington, PAN31260Vix Aircraft Services LLC · Batesville, ARN3126ALutz Adam R · Kodiak, AKN3127JHendry Joshua R · Carthage, TNN3128NSale Reported · Kalispell, MTSale reportedN3129JEagles Flying Club · Menominee, MIN312KCBrown Keith C · Deland, FLN312MMeehan Jeff B · Blue Springs, MON312TCCorey Benjamin · Lisbon, OHN3130JStevens Donald R · North Plains, ORN3130XE & D Farms · Marienthal, KSN3131NJerrell Lawrence B · Pittsgrove, NJN3132EBlue River Aviation LLC · Palmer, AKN3132HHottenstein John C · Rifle, CON3132NBaer Nicholas · Marshall, VAN3132XMerrill Gary W · Dallas, TXN3133AProppe Karl H · Needham, MAN3133BLeighton Robert L · Mattituck, NYN3133JFour Men And A Plane LLC · New Port Richey, FLN3133NRice Gary W · San Antonio, TXN3133VFluckiger Blaine W · Logan, UTN3133XPolemarkis Anthony N · Williams Bay, WIN3134APierce Harmon A · Fenton, MIN3134BGauger William A · Mesa, AZN3134GPierce Stephan L · Graham, TXN3134JOverton Asset Group LLC · St Marvs, IAN3134NOrel Holly A · Mooresville, NCN3134XMachac Milton · Waller, TXRegistration expired, pending cancellationN3135AFlynn Sean M · Casselton, NDN3135XWilliams Vaughn E · Duncannon, PAN3136AOrvin Sanden Inc · Wyndmere, NDN3136BEasley Brennan M · Wasilla, AKN3136JGriffith Charles B · Santa Maria, CAN3137BNorrick Daniel A · Mounds View, MN
Back to AD 94-05-05 R1