AD 94-05-05 R1
Registered aircraft · 26,225
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.
N10526Giarraputo Gary L · Beaumont, TXN1052EMiller Matthew · Santa Maria, CAN1052HFay Bernard E · Eagle, AKN10534Shergi Nikolai W · Franklin, INN10548Scootair LLC · Alburgh, VTN1054FGilson Gareth F · Phoenix, AZN10557Parker Helicopter LLC · Watsonville, CAN1055HReddell Justin · Jasper, ARN10565Pribyl Cris M · Hennessey, OKN10568Buchner Mark L · Springfield, VAN10574Osterberg Douglas L · Neenah, WIN10577Hatch Arthur S Jr · Mt Vernon, TXN1057NMiller Richard L · Erie, CON1058MAir Combat Museum · Springfield, ILN10592Pedrick William M · Dixon, CAN1059EDeaero LLC · Darwin, MNN1059RDoyle Brian G · Windsor, MAN105ASJohnson Scott R · North Hampton, NHN105DPPulscher Brian J · Sand Springs, OKN105ESFrederick Sport Flyers Inc · Washington Grove, MDN105RDSunny Slope Aviation LLC · Adams, TNN105SKAerospace Trust Management LLC Trustee · Wilmington, DEN105VCBrewer Curtis E · Garland, TXN10604Bittner Vernon J · New Richmond, WIN1060HJohnston Jeffery A · Eagle River, AKN10615Tarr Sheryl L · Spokane Valley, WAN10617Kern Aviation LLC · Shafter, CAN10618Roundy Kamlah F · Monteview, IDN10621Brosh Cameron R · Loveland, CON10628Warner Daniel D · Linden, MIN10630Perez Juan Carlos · Miami Gardens, FLN10644American Flag Airlines Inc · Ft Lauderdale, FLN10645Dearborn Edward M · Acworth, GAN10647Kosko Stanley G · Seattle, WAN10649Seaplane Adventures LLC · Cheyenne, WYN1064KStein Andrew · Modesto, CAN10651Wampler Matthew T · Valles Mines, MON10653Loftin Jamie B · Shreveport, LAN10658Craigmyle William R · Cooperstown, NYN10661Colberg Sigurd E · Palmer, AKN10663General Aircraft Services LLC · Pendleton, ORN10669Loeppky Neal K · Seminole, TXN10679Samson Rene R · Lewiston, MEN1067HAmerell Kathryn · Wasilla, AKN10681Chickasha Wings Inc · Chickasha, OKN10682Thomas Edward L · West Bend, WIN10683Burton Ryne W · Astoria, ILN10687Boatright William L · Colonial Beach, VAN10688Wilson Oscar O Jr · Kountze, TXN10689Jansen Sarah · Pingree Grove, IL
Back to AD 94-05-05 R1