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.
N2740UHarowicz Richard J · Mountain Top, PAN2741CGifford Gary W · Lighthouse Point, FLN2741DGott Michael C · Fairbanks, AKN2741UNickel Aviation LLC · Williamstown, NJN2742LFisher Corey · Ardmore, OKN2742UPembroke Farm LLC · Conowingo, MDN2743C43charlie LLC · Nicollet, MNN2743DBoies Ranch Inc · Wells, NVN2743LBarnes Earl E · Live Oak, FLN2743UArmstrong John Kyle · Lovington, NMN27440Paul Wesley J · Willow, AKN2744DTaylor Rock P · Wasilla, AKN2744NFordyce Joel M · Carlton, ORN2744UFladager Daryl W · Peerless, MTN2745JRegistered aircraftN2745SGobble Larry L · Williamson, GAN2745UMidfield Aviation LLC · Caldwell, IDN2746DWheeler Evan L · North Pole, AKN2746JGelatt Joseph · Wasilla, AKN2746KMiller Rondo T · Coon Rapids, MNN2746LBeavers Timothy · Charlotte, NCN2746NLamont Chapin F · Inglis, FLN2746SBryant Stan M · Derby, KSN2747CBirtic George J · Belgrade, MTN2747DFrei Russell M · Grangeville, IDN2747KJohnson Christopher E · Fort Valley, VAN2747LGuistwhite Brian K · Etters, PAN2748CZaathof Aero LLC · Foristell, MON2748ETorok William II · Cedarville, OHN2748LCarter Reagan Tye · Beaumont, TXN2749LBeeker Martin J Jr · Plymouth, MIN274ACWelch Thomas R · Modesto, CAN274HJd Aero LLC · Chester, SDN274PDMilke Shaun · Anchorage, AKN2750CFoister Nathan · Anchorage, AKN2750SMcmichael Olen G · Antwerp, OHN2750UMartin Maximilian · Sonora, TXN2752DShapiro Sara · Olympia, WAN2752EDorman Richard E · Mesa, WAN2752NMaples Jeffery · Wilmington, DEN2752SWhite Orion H · Moses Lake, WAN27536Wacker George F Trustee · Los Angeles, CAN2753LMccartney Matthew T · Lake Tapps, WAN2753SSlownlow LLC · Kalispell, MTN2754LThompson John D · Amana, IAN2754NTanley Nicholas N · Brooksville, FLN2754SGaddis Rebekah J · Valley City, OHN2754UKirkpatrick Dan C · Little Rock, ARN2755EStephenson Gary E · Philip, SDN2756BDisher Donald D · Tavares, FL
Back to AD 94-05-05 R1