AD 85-02-05 R1
Registered aircraft · 8,920
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.
N3637PBlazek Troy L · Cottage Grove, MNN3637ZFord Kristy M · Marianna, FLN3638AManifee Doris Darlene · Black Canyon City, AZN3638PSorrell Byron D · Warren, MIN3639PJoseph Patrick S · Saint Charles, MON3639ZStahl Calvin D · Auburn, WAN3640ZElliott Frank F · Mojave, CAN3642PSkyranch Knoxville Youth Inc · Knoxville, TNN3644PHanselmann Seth · Lincoln, VTFirst renewal noticeN3647PHubbard Robert Thomas · Atlanta, GAN3648ZMow The Sky LLC · Midway, UTN3649PHelmer Daniel W · Eagle, AKN3651AAir Cowboy LLC · Roca, NEN3651PAlwine Dennis C · Chewelah, WAN3651ZCrabtree Glenn E · Guthrie, OKN3652ERipley Donald W · Uvalde, TXN3653PWright Michael · Hurricane, UTN3653ZMandibles Edward Jr · Lompoc, CAN3656AHughes James D · Stanhope, IAN3656PKennedy Lukas · Anchorage, AKN3657ZBagdon Albert B · Elbert, CON3658APrice James H · Abilene, KSN3659AZientara Jim A · Zephyrhills, FLN3661ARegistered aircraftN3661EPiper Aircraft Inc · Vero Beach, FLN3661PBradham David T · Kenai, AKN3662ZDaniel Dario M · Charlotte, NCN3664ARegistration Pending · Taylorsville, KYRegistration pendingN3665ADaffron Rodney · Ragland, ALN3666ZWedepohl Richard · Madison, WIN3668ZYork Matthew J · Waterloo, ILN3669AFadenrecht Joe D · Cashmere, WAN3670ZFaught Jeffrey R · Bismarck, NDN3673AKrehbiel David E · Hastings, MNN3676ATomes William H · Buffalo, KYN3676EPiper Aircraft Inc · Vero Beach, FLN367PBuzzard Air Service LLC · Carleton, MIN367XWBold Group Ltd · Englewood, CON3699EPiper Aircraft Inc · Vero Beach, FLN36RDProflight Inc · Wilmington, DEN36WALandreth Kevin R · Ponca City, OKN370Bas Part Sales LLC · Greeley, CON3700ACall One Inc · Clarinda, IAN3701PDibbell David L · South New Berlin, NYN3702POlson Ezra Ross · Kingman, KSFirst renewal noticeN3703PEvans Christopher W · Demotte, INN3704PAlderman Mark C · Wasilla, AKN3704ZGray Melinda G · Milan, ILN3706ZHall John L · Port Angeles, WAN3707PHamm Russell K · Owasso, OK
Back to AD 85-02-05 R1