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.
N68573Etherington Sara L · Belton, MON68574All Attitude Aviation Inc · Edgewater, FLN68575Kushner Herbert A · Bridgewater, NJN68576Robinson Neil A · Madison, WIN68579Schaefer Gerard P · Olive Branch, MSN6857HNew Mexico Flying Eagle Inc · Tucson, AZN6857PHuntsman John E · West Linn, ORN6857STailgate LLC · Felton, GAN6857UShabotynskyj Kathleen · Palm City, FLN6857WN6857w Inc · Palos Heights, ILN6857ZBarrett Jane T · Tehachapi, CAN6858DSeratt Tim · Harviell, MON6858HPrairie Skies Aviation LLC · Hutchinson, KSN6858KPreston Benjamin J · Sonoma, CAN6858NBarnes Kevin Lee · Greensboro, MDN6858UMattingly James P · Edwardsville, ILN6859HRoeper Gary Lee · Linden, MIN6859JDobberfuhl Roy · Cedarburg, WIN6859KShelton Gregory S · Midlothian, VAN6859NLozar Dianne C · La Harpe, ILN6859PPlowman Joseph E · Longmont, CON6859UFischer John C · North Highlands, CAN6859ZEd Air Inc · Oaktown, INN685ACMullerhill Inc · Hillsboro Beach, FLN685ATTexas Flight Training Aircraft 8 LLC · Wilmington, DEN685BBHeavenly Flight LLC · Cumming, GAN685CXFitzgerald David Trustee · Napa, CAN685FLDadson Tach LLC · Mesa, AZN685JAYale Companies LLC DBA · Indianapolis, INN685JBMichels David A · Louisville, KYN685JWGiurtino Joel F · Spring Hill, FLN685KMN685km LLC · Wilmington, DEN685LHChristiansen Aviation LLC · Wilmington, DEN685MAYale Companies LLC DBA · Indianapolis, INN685MDAbacus Automation Inc · Bennington, VTN685NDUnd Aerospace Foundation · Grand Forks, NDN685SMKendrick Michael L · Rochester, MNN685SPDirty Side Down Aviation LLC · Georgetown, TXN68608Oxford Aircraft Leasing LLC · Oxford, NCN6860HUniversity Of Michigan Flyers · Ann Arbor, MIN6860JApm Leasing LLC · Casper, WYN6860PRegistered aircraftN6861HViking Systems Inc · Naples, FLN6861JEwart Mark A · Shoreacres, TXN6861NCooke Douglas L · Ventura, CAN6861WLoffeimancher Richard P · Eastvale, CAN6862HStrickland J A · Fairbanks, AKN6862JTraut Joseph W · Sharon, MAN6862PWeber Phillip A · Stroudsburg, PAN6862UCromer Chet T · Anderson, SC
Back to AD 81-18-04 R2