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.
N593STN593st LLC · Bangor, MEN593VSchadle Alvan G · Soldotna, AKN5940DRunnin Rabbit LLC · Kalispell, MTN5940PSilver Arrows LLC · Beaverton, ORN5940UStrong Colin · Portland, ORFirst renewal noticeN5940ZMoore Roger W · Poinciana, FLN5941WCunningham James R · Collierville, TNN5941ZByler Jonathan P · Inman, SCN5942DFour For Flying Inc · Holyoke, CON5942HHendrickson Jacob N · Central, AKN5942LSimulation International Management Inc · Tulsa, OKN5942QBravo J Bravo Aviation LLC · Louisville, KYN5943EPlane Zane LLC · Stuart, FLN5943HPleiman Jeffrey S · Minster, OHN5943LBlackmore Marc A · Hilltop Lakes, TXN5943PHarper Carlyle W · Ocilla, GAN5943QFreeborn Andrew B · North Las Vegas, NVN5943URoth Larry · Marion, IAN5943WSallee Steven A · St George, UTN5944DBradley Dennis Michael · Myrtle Beach, SCN5944LHoover Charles J · Logansport, INN5944PMay Russell L · Las Cruces, NMN5944WFerguson Robert C · Cornelia, GAN5945DKline Paul R · Mapleton Depot, PAN5945HMccoy David L · Bear Creek, WIN5945KElston Rory · Angels Camp, CAN5945WHensley Roger A · Rosamond, CAN5945XFarwell Theodore R · Orangeville, PAN5945ZThompson Neal R · Magnolia, DEN5946DInsite Design LLC · Indianapolis, INN5946PHoward W E Barney · San Marcos, TXN5946UBlack Howard J Jr · Bethpage, TNN5946Z507 Flying Club Inc · Leetonia, OHN5947DPayne David J · Eagle River, AKN5947NGmm Records · Big Pine Key, FLN5947PJam Naba Sem LLC · Beavercreek, OHN5947QMorales Nelson · Hendersonville, NCN5947WPierce Colby · Midland, TXN5948DHumble Servant LLC · Salem, WIN5948ETlt Legacy LLC · Fort Worth, TXN5948POverstreet Robert S · Clarksville, VAN5948QKrull Lynn · Thompson, IAN5949DWick Marcel P · Warsaw, NYN5949HPierce Stephan L · Graham, TXN5949PDyer Thomas L · Sparks, NVN5949U5949 Inc · Boulder City, NVN5949WSutton Warren L · Loris, SCN594AMMaarouf Mike · Taylor Lk Vlg, TXN594CEBertsch Paul J · Houston, TXN594CPCivil Air Patrol · Maxwell Afb, AL
Back to AD 81-18-04 R2