AD 81-18-04 R2
Registered aircraft · 81,733
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:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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.
N727PMMiddlebrook Paul E · Penn Yan, NYN727RStyer David L · Mount Gilead, OHN727RCKelley Aircraft LLC · Weyers Cave, VAN727RDRogers Randall E · Palatka, FLN727RHRegistered aircraftN727RMMarkle Robert L Jr · Cranberry Township, PAN727RVHodge Dennis M · Marion, IAN727SFRenko Steven E · Elmira, NYN727SPElite Approach LLC · Chesterfield, MON727TCSandpiper Air LLC · Dickinson, TXN727TDLean Aviation LLC · Saint Augustine, FLN727TGWolf Aviation LLC · Beaufort, SCN727TLLangebrake Lawrence C · Saint Petersburg, FLN727TMModesto Vapor Trails · Modesto, CAN727TSStreng Terry E · Columbus, OHN727VTFeber David G · Los Gatos, CAN727WMMd Air Ops LLC · High Springs, FLN727WVVoelcker Wolfgang Ap · Sutter Creek, CAN727ZWBergen Brady · Junction City, KSN7280CGriff Air LLC · Aurora, ORN7280DLavin Gregory S · Chugiak, AKN7280FHarmon Sharon O · Pasco, WAFirst renewal noticeN7281DMartin Michael J · Anchorage, AKN7281JBilbrey Don R · Georgetown, OHN7281PGuardian Peaks Airways LLC · Portland, ORN7281YGo For Flight LLC · Minneapolis, MNN7282ABell Helicopters LLC · Melbourne, FLN7282JWirth Alan Patrick · Callaway, MDN7282LPennau Karl · Fond Du Lac, WIN7282NWtm Consulting LLC · Williamsburg, VAN7282VBrant Owen D · Delta Jct, AKN7282WHoracio Marcelo Knop · Hialeah, FLN7282ZSimmons Aviation Services LLC · Pawcatuck, CTN7283KTuttle Jeffery D · Victoria, TXN7284CSeed Richard J IV · Wicomico Church, VAN7284GFisher Global LLC · Faulkner, ARN7284JGiermek Peter T · Olean, NYN7284LGriffin Alvin G · Mechanicsville, MDN7285FKulp Clayton H · Wichita, KSN7285LMurrell David Tyler · Pensacola, FLN7286CWalker David L · Louisville, KYFirst renewal noticeN7286LCover George A · Thayer, MON7286QLacombe Bryan K · Rockwall, TXN7286WMy Bird Is Bigger Than Yours LLC · Fort Myers, FLN7286YReagan Scott Lllp · Mount Pleasant, SCN7287GTen Mile Ranch Inc · Vale, ORN7287JJames Leroy R · Renfrew, PAN7287KClapp Carl W · Edmonds, WAN7287PTwo Dot Aircraft LLC · Kalispell, MTN7287WLebouef Kelly J · Rayne, LA
Back to AD 81-18-04 R2