AD 75-12-08
Registered aircraft · 949
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:75-12-08')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-12-08')
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:75-12-08') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-12-08') 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.
N25966Emerson Sterling L · Topeka, KSN25967Sky Adventures Inc · Oxford, MIN25978Bliss Stephen D · Norwich, NYN2597GSherman Carol L · Kansas City, MON2597WMontague Terry W · Centralia, MON2597YNicol Scott M · Mesa, AZN25987Capt N Cutty Inc · Allenton, MIN2598DGarner Walter Charles · Indn Hbr Bch, FLN25991Miller Russell E · Farmdale, OHN27035Blue Ridge Hot Air Balloons LLC · Front Royal, VAN27085Stefan Karl · Greer, SCN27105Payne Ralph J · Hastings, MIN27109Hannigan Joyce J · Colorado Springs, CON273RBSharpe Timothy M · Statesville, NCN292EWCarlson Emily K · Topeka, KSN3000SRivas Stacee L · Sanford, NCN3001HSmart Rex L · Albuquerque, NMN3003G605 Balloon Ride LLC · Sioux Falls, SDN3003RHeard Cary D · Winnemucca, NVN3003SLeblanc Giles N · Lewiston, MEN3004QFoote Roy F · Boise, IDN30050Erwin Keith S Jr · Milford, NJN3005PRocky Mountain Balloon Adventures · Pagosa Springs, CON3007RRoesch Jonathan D · Gilbert, AZN30137Amazing Adventures Inc · Temecula, CAN3013RNew Market Aeronautics LLC · Middleburg, VAN3014BPonticelli John Thomas · East Bend, NCN3014YSkyscapes Of America LLC · Daytona Beach, FLN3015MMurai Koh I · Yamhill, ORN3016XErwin Keith S Jr · Milford, NJN3017BJ&D Bridgewater Inc · Blairstown, IAN3017DBalloon Detail Inc · Norwich, NYN3017FWilkinson Steve DBA · Lake Havasu City, AZN3017SSky Adventures · Oxford, MIN3018CCarolina High Hot Air Balloon Co LLC · Four Oaks, NCN3019CCarolina High Hot Air Balloon Co LLC · Four Oaks, NCN304BBFirewalker Balloon Adventures LLC · Battle Creek, MIN3077LWerder Harold D · Hudson, FLFirst renewal noticeN3078EEgerton Clinton W · Brevard, NCN3081KBerka Joel M · Binghamton, NYN3084BPowers Daron A · Pewaukee, WIN3085ZAeronautical Solutions LLC · Taos, NMN3087XEwing Ostergaard Andrea R · Crystal Lake, ILN308AAlbuquerque Balloon Advertising LLC · Albuquerque, NMN30922Hart Randy Alan · Meridian, IDN3095BLake Air LLC · Richland, MIN3099GGlaeser Lilyan C · Carbondale, ILN31009Baldwin Thomas R · Asbury, NJN31059Capt'N Cutty Inc · Allenton, MIN3105JGuzzo Marla S · Niwot, CO
Back to AD 75-12-08