AD 80-25-07 R1
Registered aircraft · 25,370
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.
N5721QRawski Aviation LLC · Kingwood, TXN5722QMyers Shawn · Louisville, KYN5724JPurdue Aviation LLC · West Lafayette, INN57252Mooney Flyers LLC · Crystal Lake, ILN57257Moulton Lawrence W · Westlake Village, CAN57259Trantham Joey L · Panama City, FLN5725QBaughman Air Service Inc · Stockton, KSN57267Devine Robert · Albuquerque, NMN5726MSolano Edwin G · Fort Atkinson, WIN5726QAllen Colin S · Leonardtown, MDN5727EZeitvogel Jeanine · Gulf Shores, ALN57280Conklin Michael L · Grand Blanc, MIN57283Collins James L · Bradenton, FLN5728QKuss Luke A · Hutto, TXN572RJUniversity Of Michigan Flyers Inc · Ann Arbor, MIN5730JLindley Field Flying School LLC · Greensboro, NCN5731QSomers James K Trustee · Montgomery, TXN5732EWynn Josh · Bucyrus, OHN5732QAir Lords Inc · Middletown, DEN57336Wolfe Roark · Flagstaff, AZN5733QBlue Skies Flying Club · Burien, WAN5734JBewley Terry V · White Oak, TXN5735PPlanecrazyd LLC · Portal, GAN5735QBeler Arnold Ray II · Redlands, CAN5736QWard Troy · Odessa, TXN57376Christian Medical Mission Aviation Support Inc · Waco, TXN5737NBingham Clifton Wade · West Lafayette, INN5737QBross Stephen W · Burke, VAN57383Dalley Robert C · Waldron, INN57385Victor Foxtrot LLC · Scott City, KSN57386Arair LLC · Kindred, NDN5738QGuillen Gregorio J · Lopatcong, NJN57390Beyer Mark E · Towanda, KSN57394Mccombs Evan · Peyton, CON57395Zangs William J · Poplar Grove, ILN57399Aerobatic 8kcab Holdings LLC · Murchison, TXN5739JIntegrative Aerospace Corp · Aliso Viejo, CAN5739QMorell Timothy S · Lino Lakes, MNN57401Adams Kenneth · Marana, AZN57404Cp Aviation Inc · Santa Paula, CAN57405Shoaf Douglas G · Lake Oswego, ORN57407Britt Elaine L · Locust Grove, GAN57408Phillips Thomas G · Fairbanks, AKN5740QOasis Aero Inc · Willmar, MNN57410Eddy William Crawford III · Sugar Hill, GAN57411Gregory Larry C Trustee · Farmington, MON57412North County Flight Training Inc · Carlsbad, CAN57413Miller Sybille A · Ashburn, VAN57420Florida Man Aviation LLC · Saint Petersburg, FLN57421Snider Roger A · Harlem, MT
Back to AD 80-25-07 R1