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.
N3131YPaero Contracting LLC · Middletown, OHN3132CBlack Eric · Fort Jones, CAN3132YLampkin George G · Forney, TXN3133RSprott James D · Harrison, ARN3133SMitchell Terry R · Tallahassee, FLN3134DHanson Parry B · Eagle Creek, ORN3134UBaine Larry A · Marne, MIN3135CVeech Shawn M · Big Lake, AKN3135DSkycavu Inc · Hi Rls Mtn Pk, NMNon-citizen corporation, flight hours not reportedN3135QGrf Aviation LLC · Destin, FLN3135ULogue Christopher A · Trout Run, PAN3136CPark Avenue Group Inc · Stuart, FLN3136FMurdock Lloyd W · Princeton, KYN3136QN3136q Flyers LLC · Las Vegas, NVN3136RKuntz Trucking Co · Gridley, ILN3136SSeiler Richard D · Bozeman, MTN3136YReed Jason B · Faith, SDN3137CKlausler Thomas W · Lakeville, MNN3137FJbm Endeavors LLC · Chewalah, WAN3137RGriffith Moseley Johnson & Associates Inc · Port Arthur, TXN3137SManley Robert E · Ferndale, WAN3137UCurson Randy J · Cape Coral, FLN3137YLopez Juan F Jr · Del Rio, TXN3138CTurbo-Sphere Inc · Longmont, CON3138QShepard Donald · Lake Havasu City, AZN3138R15 Rides LLC · Manteo, NCN3138URegistered aircraftN3139DGuichard Lawrence · Spokane, WAN3139QGrubbs Jerry M · Longview, TXN313CPCivil Air Patrol · Maxwell Afb, ALN313DQIler Elden · Van Nuys, CAN313GBBurnett Gregory C · Rogersville, MON313JWWright George E Jr · Homestead, FLN313MAAbrams David · Holmdel, NJN313SKJohnson Scott · Blaine, MNN3140CAthens William A · Missoula, MTN3140FWilliams Thomas G · Richland Center, WIN3140SLavell Michael J · Blue Mounds, WIN3140YParker Mccrum LLC · Eugene, ORN3141DNelson Donald W · Aurora, CON3141FDoerr John · Sandy, ORN3141RIncze Bela · Morgan Hill, CAN3141SValley Excavation And Grading Inc · Chatsworth, CAN3141UMo2 Investing LLC · Springfield, MON3142CItm Electronics Inc · Greenleaf, IDN3142QRogers James · Summerfield, FLN3142RSharp Media Group LLC · Kansas City, MON3142SB&G Aircraft LLC · Greensboro, GAN3142YOdom Aviation Inc · Cabot, ARN3143QJlm Management LLC · Clarion, PA
Back to AD 84-10-01 R1