AD 80-25-07 R1
Registered aircraft · 25,368
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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.
N924SAGiber Sharon G · New Port Richey, FLN9251MFelix Eric · Oshkosh, WIN9252HStratus Aviation LLC DBA · Vacaville, CAN9252MStarfox Aero LLC · Hays, KSN9252RBank Of Utah Trustee · Salt Lake City, UTN9253RDr Equipment LLC · Ackerly, TXN9253VChristopher Damien · Savannah, GAN92548Pulliam Richard W · Henryetta, OKN9254HShipley Donald E · Alpine, TXN9254MWhittaker Victor · Panama City Beach, FLN9254VLeyden Jar LLC · Greeneville, TNN9256MLone Star Magni Gyro Inc · Taylor, TXN9256VDirschka Paul · Blandford, MAN92570Becker Steven H · Prescott, AZN9257HTaf Aerial Services LLC · Beeville, TXN9257MMouser Ryan D · Paragould, ARN9257VKelley Gaylord L Jr · Murrells Inlet, SCN9258MJones Mavin D · Monroe, UTN92593Snider Scott E DBA · Turner, MTN92595Bearfight Aviation LLC · Dover, DEN9259HBooke Phillip Austin · Anniston, ALN925CBDhani Errol · Locust Grove, GAN925ERCrosswell Joe D · Springtown, TXN925JHLightning Air Group LLC · Fort Worth, TXN925MML A M Capital Management LLC · Sheridan, WYN925PBRegistered aircraftN9260MRegistered aircraftN9260RVroom David H · Oro Valley, AZN9260VBravo Aero LLC · Concord, NCN92617Stahl Raifen · Anchorage, AKN9261GAllred Bobby A · Centre, ALN9261HSchrom Frederick A · Carlisle, PAN9261MPickett Trina M · Riverside, CAN9262HAero Maintenance Inc · Vancouver, WAN9262VAdams Kirk A · Sanger, CAN9263HPj Aviation Holding LLC Trustee · Eden Prairie, MNN9263MBarefoot Releaf LLC · Scottsdale, AZN9263VOrton Leon J · Nibley, UTN9264MRegistered aircraftN9264RAir Dakota Flite Inc · Hettinger, NDN9264VSly David P · Nevada, IAN9265HCleveland Douglas P · Live Oak, FLN9265MKobe Thomas J · Lake Placid, FLN9266TCrosswind Aviation Inc · Oakley, KSN9267VCabina Maintenance LLC · Waxhaw, NCN9268MN9268m LLC · Reseda, CAN9268TRooney James J · Friendswood, TXN9268VNelson Edward C · Manorville, NYN9269HLargen Gregory K · Benton, KSN9269MHernandez Raul H · Chico, CA
Back to AD 80-25-07 R1