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.
N594HKeading Helicopter LLC · Shoshone, IDFirst renewal noticeN594JWNelson Travis E · Richland, MTN594MTMiddle Tennessee State University · Murfreesboro, TNN594RVGreer Charles C · San Diego, CAN594SPFrench David J · Aptos, CAN5950KCoco Aircraft Inc · Merritt Island, FLN5950PBohaty Mark P · Benton, KSN5950WRegistered aircraftN5951DBriscoe Charles W · Wichita Falls, TXN5951ELlano Alfonso · Tucson, AZN5951HEndres Merrick A · Riverview, FLN5951LWilson Joe M · Lucedale, MSN5951ULink David R · The Dalles, ORN5951ZKlausler Andrew T · New Market, MNN5952Pitts 5952 LLC · Bow, WAN5952HTri-Lambs LLC · Lincoln, NEN5952LAskew Stell B III · Durham, NCN5952PSchau Kenneth · New Athens, ILN5952SMaestro Aviation LLC · Anson, TXN5952USlocombe Walter B · Bossier City, LAN5952ZEvans Jerold A · Paradise, CAN5953LTaylor John W Jr · Metairie, LAN5953QRoberts Stephen C · San Marcos, TXN5953SKahn Richard K · Middletown, DEN5953WDavis Kyle G · Waseca, MNN5953ZBennett Robert L · Longmont, CON5954HRegistration Pending · Portland, ORRegistration pending, canceledN5954QDominique Jon Andrew · Lenoir, NCN5954SLancaster Andy R · Midlothian, TXN5954UReed Mark A · San Bernardino, CAN5954WHemacinto Valley Flying Club · Hemet, CAN5955EClover Park Technical College · Tacoma, WAN5955HHerb Meloche Ltd · West Allis, WIN5955UBailey Doane E · Sharpsville, PAN5955VWestern Aircraft Solutions · Temecula, CAN5956DGianquinto Jason D · Bakersfield, CAN5956EWalsh James · Hayden, IDN5956QHunt Brian A · Alexandria, VAN5956ULindsey Gary E Jr · South Deerfield, MAN5958HFreed Richard H · Watervliet, MIN5958QInnovative Orthopedics Inc · Arcadia, OKN5958WWise Aviation Solutions LLC · Rio Vista, TXN5959HMclemore Arthur B · Aledo, TXN5959KKilo-Kilo LLC · Wausau, WIN5959UOhnstad Andrew J · Webster, MNN595ACBordlemay John J · Lewisberry, PAN595BSNoll Jason Michael · Geneva, ILN595CMChvatal Robert J · Litchfield, MNN595DBStar Magic (Www) Inc · New York, NYN595DJSanchez Daniel J · Gonzales, LA
Back to AD 81-18-04 R2