AD 84-10-01 R1
Registered aircraft · 20,483
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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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.
N3830GAerial Transport LLC · Dover, DEN3830YRice Kevin L · Pleasant View, CON3831GPanepinto Lane L · Lafitte, LAN3832DKim Sungtae · Fort Worth, TXN3832YMtfg LLC · Hayden, IDN3833DEnt Flight Services · Las Vegas, NVN3834DMilan Ruth A · Edmonds, WAN3835YCarlton Jeffery G · Great Falls, MTN3837DCameron Russell A · Fort Benton, MTN3837YRounds Chris · Waller, TXN3838GGolden Eagle Outfitters Inc · Delta Junction, AKN3839DHot Rod Aviation LLC · Fayetteville, ARN383KDT-6 LLC · Wilmington, DEN383MGMissionary Air Group · Burlington, NCN3840DLangbehn Lee W · Great Falls, MTN3841GWhetzel Michael L · Ukiah, CAN3843DNichols Bryan M · Canute, OKN3843GBash Dennis W Jr · Wasilla, AKN3844YManarin Roland R · Lakemont, GAN3845DTeam Gateway LLC · Lewes, DEN3845Y1st Due Emergency Response Solutions LLC · Bartlett, KSN3846DAshiku Phillip · Ukiah, CAN3847DPrice David W · Lynn Haven, FLN3847YLee Justin W · Maud, TXN3849DMellor Bradford A · Spanish Fork, UTN384MGMissionary Air Group Inc · Burlington, NCN3850YPoole Vernon N · Melstone, MTN3851DSale Reported · Darby, MTSale reported, pending cancellationN3851YMckie-Voerste Travis K · Chatsworth, GAN3852CWilson Kirk B · Glennallen, AKN3853DMccabe Ryan · Las Vegas, NVN3853G3853g LLC · Umatilla, FLN3853YRafter Bar B LLC · Ashland City, TNN3854CAnderson Clint T · Corsicana, TXN3854DTjp@Jax Inc · Zephyrhills, FLN3854YJames Wilson Smith Enterprises LLC · Athens, GAN3855GMoore David · Lexington, TXN3857YLutz Matthew B · Jackson, TNN3858RBaugh David · Kirkland, WAN3859CSweet Phillips R · Laguna Beach, CAN3859YMorse Donald W · Priest Lake, IDFirst renewal noticeN385MAPesek Larry Paul · Steinhatchee, FLN385RBNational Aircraft Leasing Corp · Greenville, DEN385SPAircraft Trustee Services Inc Trustee · Dover, DEN385TDHomestead Helicopters Inc · Missoula, MTN3861CBuben Michael · Chandler, AZN3861YMiller Todd D · Fort Wayne, INN3862DReady Aim Flyer LLC · New Castle, DEN3862GRenfro Michael W · Bethel, AKN3863DDulley Tony A · Nine Mile Falls, WA
Back to AD 84-10-01 R1