AD 85-02-05 R1
Registered aircraft · 8,921
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:85-02-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:85-02-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:85-02-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:85-02-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.
N3327BHilgendorf Douglas A · Welcome, MNN3327ZMessinger Donald C · Wasilla, AKN3328ATulis David · Frederick, MDN3328BHarper Ken C · Kenai, AKN3329PStradley Anna M Trustee · Bozeman, MTN3330AJordan Don T · Midlothian, TXN3331ABurgess Roy S · Lincoln, NEN3332AMarinan Steve · Sanger, TXN3332ZWeisenburger Adam A · Seeley Lake, MTN3333BNorlin Lary G · Indianola, IAN3335ATwotards Aviation LLC · Moses Lake, WAN3335BHutsell James M · Miamisburg, OHN3335ZGreen Francis E III · Frankfort, NYN3336BNelson Morales · Hendersonville, NCN3336ZCedar Mark P · Cherokee, IAN3337BJohnson Rader · Cedar City, UTN3338BLvft Aviation Inc · Wilmington, DEN3338ZKeil Lawrence L · Anchorage, AKN3339BStraub Kerry D · Grants Pass, ORN3339PGeorge James Cooper · Lenoir, NCN333CBSecondary Minimums Task Force LLC · Kalispell, MTN333CREob Aviation LLC · Grand Haven, MIN333CXFlying Bs LLC · Canby, ORN333FSAerodrome LLC · Louisville, KYN333HJSchlender Mike · Clintonville, WIN333HYFrantz Paul B · Abbeville, GAN333JDDouglas Aero Inc · Fort Lauderdale, FLN333PBBourne Hoppe & Associates LLC · Midland, MIN333SNHub City Aviation Academy LLC · Lubbock, TXN333VAXrrx Inc · Wilmington, DEN333WYJrm Wings LLC · Farmington, UTN3340BHao Hangar Rats LLC · Fairfield, OHN3341AHolbrook Tmothy D · Traverse City, MIN3341BPort Townsend Aero Museum · Port Townsend, WAN3341PDahl Troy M · Cedar Rapids, IAN3342BAmy Jason R · Minneola, KSN3342ZNies Juergen · Winchester, VAN3344BVan Vleet Clifford · Sierra Vista, AZN3346BHospodar Robert P · Georgetown, PAN3346PDramstad Flying Service LLC · Helena, MTN3347ARegistered aircraftN3349ZPorter Curtiss L · Woodscross, UTN3350ZKintner Daniel S · Conyers, GAN3352ZLoppnow Martin L · Yermo, CAN3353PHeffron Jacob L · Little Falls, MNN33542Schmidt David L · Wasilla, AKN3354ZJohnson Charles D · Benson, AZN3357ZHannon Harland N · Big Lake, AKN3359ZKistler Stephen M Trustee · Monument, KSN335BFSouthern Aircraft Consultancy Inc Trustee · Casper, WY
Back to AD 85-02-05 R1