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.
N3108KKirgiss Randy M · Johnson City, TNN3110CKent Karen S · Port Allen, LAN3119HEmpty Pockets Balloon Team LLC · Gallup, NMN3120YBlue Ridge Hot Air Balloons LLC · Front Royal, VAN31226Scarberry Wm G Jr · Piney Flats, TNN3125KCole Timothy S · Greeley, CON3126FReid Eric M · Albany, ORN31271Allison J R · Albuquerque, NMN31326Balloon Stormers Inc · Ashland, MON313HDWilson Daniel E · Tucson, AZN31409Wilkinson Steve · Lake Havasu, AZN31427Benzer Terry L · Blountville, TNN31527Hutchinson Brian · Bonner Springs, KSN31544Keller Sarah A · Huntertown, INN3155JLady Jester Natchez LLC · Natchez, MSN31664Forenz Thomas · Georgetown, CON3166JCline J Donald · Greensboro, NCN3171LGoodnow Tony A · Topeka, KSN3173KSky Adventures Inc · Oxford, MIN31744Island Balloons Inc · Lanexa, VAN3175SStarr William K · Buckeye, AZN3176QBegin Echo R · Reno, NVN3177UAubol-Hanks Nancy B · Bosque Farms, NMN3178MBart Francis A · Old Town, FLN317WSilver Lining Ballooning LLC · Prairie Grove, ARN31800Cameron The Pilot LLC · Casper, WYN3180SEbiner Ann B · Santa Rosa, CAN3185TSky Adventures Inc · Oxford, MIN31877Clemons Louise · Truro, IAN31910Ristaino Damien Edward · Charlotte, NCN3191FPowell Timoth · Sanford, NCN3198TDuren Richard S · Shelby, NCN3202UJohnson Shaun T · Grand Forks, NDN3202YPennell Mark · Sparta, NCN3208GNapa Valley Aloft Inc · Yountville, CAN3209AAllred Kelly M · Longmont, CON3209MOld World Balloonery LLC · Overland Park, KSN32104Jones Brian C · Sapulpa, OKN3210CBalloon Stormers Inc · Ashland, MON3210RSena Paul A · Worthington, MAN3211ZSokovich Caleb S · Watertown, WIN3212AMccomb Jay · Hendersonville, TNN3213HMoormann Richard C · Winston Salem, NCN3213TDelmarva Balloon Rides LLC · Chester, MDN32143Eagle James A · Candler, NCN3218BWicker Basket Balloon Center · Wixom, MIN3219QCrites Walter W · Auburn, MEN3219YWiltse Bret A · Johnston, IAN32309Brownell Lynn K · Eagle Bridge, NYN32343Cross Paul · Monteagle, TN
Back to AD 75-12-08