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.
N158AERobinson Bruce A · Salinas, CAN158DMKeppers Craig J · Anchorage, AKN158DSHolm Michael J · Glendale, AZN158YMachamer John K · Gettysburg, PAN1590QHeyde Raymond E · Hernando, FLN1591QBas Part Sales LLC · Greeley, CON1592BMcneill Daniel A · Placerville, CAN1592QProietto Nicholas Philip · West Grove, PAN1593YBolsover Douglas J · Cameron Park, CAN1594Ogden Christopher S · Chewelah, WAN1594BTinkler Sharon W · Tullahoma, TNN1594QLesniak Myra D · Hillman, MNN1594YSexson Lance Mason · Ogallala, NEN1597YHelderman Laban W · Newton, NCN1598NHill Evan M · Wasilla, AKN1599PSnowden Robert W · Mason, TXN1599QGonzalez Anthony H · Rancho Cordova, CAN159AEGalbari Geno · Wales, WIN159JMWyttenbach Joel N · Sauk City, WIN159LCWebstrong Aviation LLC · Conway, ARN15AABell Shad G · Centerburg, OHN15ACSafran Brian J · Valley City, OHN15AVRoquemore William A Jr · Lakeland, GAN15CUSalvato Kyle · Key Largo, FLN15HHHulboy Jeffrey K · Churubusco, INN15JMid Atlantic Air Museum · Reading, PAN15LCMac Flight LLC · Conway, ARN15LLBurk Ross · Casper, WYFirst renewal noticeN15PE15pe LLC · Lincoln, NEN15SGStump Clarence H Jr Trustee · Loveland, CON15SRAllen Rodney · Connellsville, PAN16003Coats Jeff · Twin Falls, IDN16006Lazor Ron E · Middlefield, CTN16007Cottrell Alan L · Toano, VAN1600DBallard Thomas L · Seguin, TXFirst renewal noticeN1600KDenzil Charles David · Southmayd, TXN16011Dennis Ronnie Lee · Odessa, FLN16012Filasky Joseph J · Aquebogue, NYN16015Rodriguez Richard · Indianapolis, INN16017Maley Adam W · Shinnston, WVN1601NStrahan Ronald R · Girard, KSN1601QHesse Ginger C · Stacy, MNN1601VIte LLC · St Pete Beach, FLN16026B&R Aircraft LLC · Wadsworth, OHN16029Cabrera Ramon F · Guttenberg, NJN1602FWilliams Richard E · Seaford, DEN16033Mccosh Hunter B · Fort Wainwright, AKN1603FAbouelleil Hisham · Suffield, CTN1603NEaves Donald R · Byhalia, MSN16042Weaver Peter D · Davis, CA
Back to AD 94-05-05 R1