AD 80-25-07 R1
Registered aircraft · 25,369
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.
N711UATuthill Andrew M · Etna, NHN711WEMelbourne Flight Training LLC · Melbourne, FLN711ZHappenstance LLC · Cabot, ARN7120GSky Hook Inc · Red Wing, MNN7120QClodfelter Terry Lynn · Norwood, NCN7120VOpulent Investments LLC · Mandan, NDN7122GBirmingham Flight Center LLC · Birmingham, ALN7122VProvance Brent L · Granbury, TXN7123GJet & Rotor Aviation LLC · Sacramento, CAN7123UMatherly Frank · Greenbrier, TNN7124QVy Aviation LLC · Gentry, ARN7124UGoss Brendan · Shady Shores, TXN7124VHunter Cameron Brooks · Keller, TXN7125GBohannan Joshua S · Rose Hill, KSFirst renewal noticeN7125QPiedmont Flight Inc · Winston Salem, NCN7125UTakacs Robert S · Oxford, CTN7125VSutphen James A · Henderson, TXN7127VChenal Robert B · Pawcatuck, CTN7128GDsr Cherokee 180 LLC · Dallas, TXN7128QAmerican Patrols Inc · Midland, TXN7128VLinville Aero LLC · Chapel Hill, NCN7129GSmith Lyle D · San Marcos, TXN7129QG Alaouie LLC · Port Austin, MIN712DAlpha Aviation LLC · Dalhart, TXN712KWing John David · Guymon, OKN712TTAb Cessna LLC · Wilmington, NCN7130VKerkstra Hilary · Portage, MIN7131SMaya Aircraft Holdings LLC · Lee, NHN7132QAero Quest LLC · Olive Branch, MSN7132VCrowley Preston R · Northport, ALN7133QPage Aerial Service Inc · Rochelle, ILN7133VKing Mitchell Earl · Columbus, MSN7134UDalton James D · Pasadena, TXN7135QHoman Larry E · Sigourney, IAN7135VHerkoltz Patrick Alan · Phelan, CAN7136QPa Lawrence LLC · Anchorage, AKN7136VHickman Jared · Bothell, WAN7136XArchangel Michael Flyers Inc · Princeville, HIN7137UMalone David V · Oklahoma City, OKN7137VZelek Daniel · Wurtsboro, NYN7138UHinkle Robert J · Caldwell, IDN7138VColombo Brian M · Oswego, NYN7139GSkysg LLC · Eugene, ORN7139QFernander David · Enterprise, ALN7139TPhilpot John Michael · Liberty, MON7139UMott Charles A Jr · Chesapeake, VAN713BMMathieu Robert B · Delhi, LAN713JADesert Sealants Corp · Queen Creek, AZN713JKSbarounis Carl A · Torrance, CAN713JPArizona Technical Construction LLC · Lake Havasu City, AZ
Back to AD 80-25-07 R1