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.
N3283BGay Morgan C · Tunkhannock, PAN3284BGlover Gary J · Columbia, SCN3285PLsop Rentals Premier Asset Management LLC · Gowanda, NYN3292PCrosswindz Ranch LLC · Seminole, TXN3298PCross Albert B III · Salinas, CAN329SDAce Flight Center Inc · St Thomas, VIN32DMHulme Thomas L · Fountain Hills, AZN32JDDuflo Spray Chemical Inc · Bremen, NYN32RWSkylens LLC · Hammond, LAN32VUVincennes University · Vincennes, INN3300BJohnson Rusty E · Enumclaw, WAN3300ZKoliastasis Pete · Reno, NVN3301ASmith Randall P · Fort Worth, TXN3301BLux Jason M · King Salmon, AKN3301PDramstad Flying Service LLC · Helena, MTN3301ZWood Paul S · Lawton, OKN3302BNehrkorn Ruediger · Slate Hill, NYN3302ZMeginnes Mark A · Tucson, AZN3303ZZanis Paul M · Wolfeboro, NHN3304BDoty Danial J · Talkeetna, AKN3304PBucket List Aviation LLC · San Jose, CAN3305PAir Royal · Middletown, DEN3307PAlbano James R · Oakham, MAFirst renewal noticeN3308ARegistered aircraftN3308ZWeber Daniel Troy · Port Charlotte, FLN3309ZRubbert Randy C · Reynolds, NDN330ARegistered aircraftN330CPCharlie Pop Flyers Inc · Jacksonville, FLN330JGCultra LLC · Naples, FLN330KRCherry Hill Aviation Inc · Freetown, INN3310AKonrad Robert M · Centennial, CON3310BHilgendorf Ross E · Welcome, MNN3311ARitchie John A Jr · Gold Hill, NCN3311BJackson Tal H · Spearman, TXN3312ARegistration Pending · Myerstown, PARegistration pendingN3312ZDemontigny Tyler R · Redding, CAN3313BOlling Stanley J Trustee · Wanatah, INN3314AMichalek Construction Inc · Keosauqua, IAN3316AStanley Daniel P · Hindman, KYN3316PCrew Sourcing Inc · Wilmington, DEN3318BDeane Daniel G · Park City, UTN3319AThomas Brian D · Corning, IAN331GPDodson International Parts Inc · Rantoul, KSN3320ZHolton Mark · Lebanon, MON3321BLee Donald R · Talkeetna, AKN3322AJohnson Ezra M · Rhinelander, WIN3322GLone Star Flight Museum · Houston, TXN3323BCenterville Air Techs LLC · Centerville, IAN3325AAustin James M · Ft Worth, TXN3326PDean Marshall H · El Paso, TX
Back to AD 85-02-05 R1