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.
N2568LBuckles Lyndell G Trustee · Naples, FLFirst renewal noticeN2568SRutherford Marcia A · Castle Rock, CON2570EDekoevend Enterprises Inc · Fort Garland, CON2570GMills Ronald Keith · Piedmont, OKN2570WRutan Aaron · Greentown, INN2570YCity Of Riverton · Riverton, WYN25711Russell Luke S · North Canton, OHFirst renewal noticeN25713Maverick Balloons LLC · Commerce Township, MIN25714Reed David M · Lenexa, KSN25718Render Keegan C · Indianola, IAN2571WWright Bryan D · Tallahassee, FLN25735Schmitt Ruth Ann · Mineral Point, WIN2573BBart Francis A · Old Town, FLN25744Hoch Darcy R · Milo, IAN25747Suarez Michael A · Albuquerque, NMN2575PCampbell Philip L · Bayfield, CON2576UHasson James J · Meridian, MSN25774Barnes Alfred C III · Norwich, NYN2578GWolters Jim A · Holts Summit, MON2578VWaddell Paul Patrick · Front Royal, VAN2579ZKent Karen S · Port Allen, LAN2580AKirk Chad Justin · Zebulon, NCN2580FMullin James G · Palisade, CON2580NOberman Michael W · Queen City, MON2580YShort Dennis L · Broken Arrow, OKN2580ZWatkins Tristan · Anthem, AZN2581EFitzsimmons Christian · Mount Horeb, WIN2581SSaul Garrett M · Temecula, CAN25823Fritze Mark A · Tallahassee, FLN25828Vaeth John P · Colorado Springs, CON2582UDavis Tyler J · Montrose, CON2584LSky Adventures · Oxford, MIN2584XBalloonstormers Inc · Ashland, MON25857Aubreyaire LLC · Longview, TXN25866Turner Steve · Half Moon Bay, CAN2586EBlake Stephanie · Morgantown, WVN2587ZWhitten Randy L · Republic, MON25884Parker Brian D · Marcellus, NYN2588GGoodnow Tony A · Topeka, KSN2588USky Adventures Inc · Oxford, MIN25897Sutter Denis · Hallsville, MON25902Blue Ridge Hot Air Balloons LLC · Front Royal, VAN2590LBallard James · Neosho, MON2590PYadkin Valley Balloon Adventures Inc · Tobaccoville, NCN2590YCarter William A · Pleasant Garden, NCN2592KSilk Kyle J · Cuyahoga Falls, OHN2592UField Kimberly A · Munnsville, NYN25935Kelley Justin W · Auburn, MEN2593JJ M H Inc · Townville, SCN2593MGoosey Rick W · Pleasant Hill, MO
Back to AD 75-12-08