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.
N733VLYuma Ag Service Inc · Yuma, CON733VRLegends Air Center LLC · Bentonville, ARN733VSClemson Flying Club Inc · Seneca, SCN733WCDrouin Roger R · Naples, FLN733WEAirwaves Nsb LLC · New Smyrna Beach, FLN733WGMiloud Chad · Fort Worth, TXN733WHFritts Paul D · Southworth, WAN733WLShadduck James N · Annandale, MNN733WMNakamura Hajime Trustee · Long Beach, CAN733WSAirgo Inc · Centralia, ILN733WTAnderson Aviation Services Inc · Carlsbad, CAN733WUAviator Air Flight School LLC · Grand Prairie, TXN733WVRatzlaff Jeff DBA · Langdon, NDN733WWFm Aviation Inc · Concord, CAN733WXSpartan Marine Co · Capistrano Beach, CAN733WYFlys And Floats C172 LLC · Panama City Beach, FLN733XMiddleton Mary David · Austin, TXN733XBBlair Burkholder Inc · Erie, CON733XEAeroventures Flying Club Inc · Lilburn, GAN733XFBeaugez Gregory C · Perkinston, MSN733XKSabol Edward J Trustee · Leominster, MAN733XLAirspeed Marketing LLC · Phoenix, AZN733XMRoatis Calin V · Sacramento, CAN733XNFlyn Go LLC · Spring, TXN733XZ3650 Aircraft Inc · Bakersfield, CAN733YBZulu Aerospace Services LLC · Peoria, AZN733YEDiederich Fred H · Fayette City, PAN733YGLeaschauer Eitan · San Jose, CAN733YHBailey Gordon J · Fayetteville, GAN733YPMiller Robert · Battle Creek, MIN733YRBoccaccio Donald O · Hypoluxo, FLN733YTRegistration Pending · Centereach, NYRegistration pendingN733YYTetrault Howard D · Malabar, FLN733YZSeaplane Adventures LLC · Cheyenne, WYN733ZBMidstate Aviation 1 LLC · Owosso, MIN733ZEKgr Aviation LLC · Austin, TXN733ZKStone Aviation LLC · Sacramento, CAN733ZNAtmospheric Vehicle & Spacecraft Flt Exploration · Rch Palos Vrd, CAN733ZPFruit Belt Flyers Inc · Saint Joseph, MIN733ZSMccown Jamey · Bayfield, CON733ZYHess Garrett J · Fullerton, CAN733ZZDuncan James · La Porte, TXN734United States Department Of Agriculture · Cedar City, UTN73401Sage Kathlene A · Bass River, MAN73407Wxly Aviat LLC · Gastonia, NCN7340BThaut Lance A · Fullerton, CAN7340LAzure 01 LLC · Canton, NYN7340PWard James A · Brentwood, TNN7340WMillar Russell J · Saint Onge, SDN7340YStark Stephen · Fort Lauderdale, FL
Back to AD 81-18-04 R2