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.
N1960PChaffee Harry · Meridian, CAN19610Berg John R · San Pedro, CAN19614Clark David R · Terrebonne, ORN19618Seymour David E · Evergreen, CON1961FRemove B4 Flight LLC · Joplin, MON19620Schmidt Jeffrey A · Othello, WAFirst renewal noticeN19622Baker Timothy G · Curtis, NEN19624Jlinn Aviation Inc · Quinlan, TXN19625Novak Daniel F · Palmyra, WIN19629Anvab Inc DBA · Concord, NHN19630Brignoni Ruben Mercado · Isabela, PRN1963QJohnson Clinton B · Alpharetta, GAN1963VFerguson George W · Vero Beach, FLN19640George Gary D · Humble, TXN19643Kuester Ryan J · West Point, NEN19644Hyde Shawn M · Columbus, OHN19646All2fly LLC · Atlanta, GAN19648Registration Pending · Cumming, GARegistration pendingN1964FLombardo Russell S · Fostoria, MIN1964QAction Air LLC · Missoula, MTN19650Wingsleasing LLC · Wichita, KSN19655Kincaid William R · Niceville, FLN19657Thomas Mark E · Corpus Christi, TXN19658Gavel Robert E Jr · Keaau, HIN19665H&L Axelsson Inc · Cape May, NJN19667Rich Lucas Aircraft Sales LLC · Lincoln Park, NJN19668Yent Kevin N · Tampa, FLN19669Sprague John F · Chico, CAN1966FD & S Aviation LLC · Spring, TXN19671Cascade Aviation LLC · Burlington, WAN19673Transair Inc · Blue Ridge, GAN19674Mcgraw Amiyah S · Jurupa Valley, CAN19676Whitman David L Jr · Centreville, VAN19679N19679 LLC · Opa Locka, FLN1967FLeander Henry Anske IV · San Antonio, TXN1967SFullerton Airport Pilot Association · Fullerton, CAN1967TSloan Jeffrey Sterling · Hazen, ARN1967USmith Bernard A · Wasilla, AKN19680Proflight Services LLC · West Newton, PAN19681J & J Shop Heliair LLC · Laurel, DEN19682Steward James Mark · Colorado Springs, CON19684Belt Jay D · Bluefield, WVN19687Dg Aviation LLC · Mechanicville, NYN19688Vista Air Inc · Pacoima, CAN1968FMedia Stew LLC · Carson City, NVN1968RCloud Transport Operations LLC · Albuquerque, NMN19692Babyshark LLC · Duncan, OKN19695Saint Aviation Inc · Dunnellon, FLN19698Northern Air Aviation LLC · Naples, IDN1969EC M & T Aero Inc · Cedar Rapids, IA
Back to AD 80-25-07 R1