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.
N7592YClover Park Technical College · Lakewood, WAN7592ZBrain Paul W · Webster City, IAN75930Rivera Aniceto · Boonton, NJN75931Alston Russell R · South Jordan, UTN75938Fiedler Aviation LLC · Suffolk, VAN7593EFrench Robert J · Ferndale, WAN7593HFricks Philip B · Piedmont, SCN7593PWaitkus James M · Oak Park, CAN7593RPiasecki Christopher Andrew · Lemont, ILN7593VBlanzy Paul J · Highland, MIN7593YEpic Aviation Leasing LLC · Puyallup, WAN75942Ward Sharon A · Lago Vista, TXN75943Savage Island Airport (Vt15) LLC · Burlington, VTN75944Noll Gregory Lloyd · Watford City, NDN7594FPierschbacher Clifton A · Marysville, WAN7594VSilly Boy Aviation LLC · Moses Lake, WAN75950West John T · Bulverde, TXN75955Belgarde Monte G · Butte, MTN75956Millennium Aviation Group LLC · Wallace, NCN7595EFlynn Andrew L · La Grande, ORN7595HKnutson Daniel T · Lodi, WIN7595JDykes Jeff · Riverside, WAN7595RTedeschi Steve · Irving, TXN7595W180 Inc · Shelby Township, MIN75967Ace Of Spades Aviation LLC · Las Vegas, NVN7596JN7596j LLC · Denver, CON7596RChocolaterie Ltd · Des Moines, IAN7596WSchaefer Hugh W · Merrick, NYN7596YRodgers Kevin M · Vacaville, CAN75971Price Ronald Anthony · Deer Park, WAN75972Aircraft Resource Center Inc · Lakeville, MNN75974733et LLC · Columbus, OHN75976Suburban Aircraft Leasing And Sales LLC · Sylvania, OHN7597FKnowles Ross Martin · Chapmanville, WVN7597KGuptill Patrick · Quinn, SDFirst renewal noticeN7597PSpinks Matthew Robert · Clarkesville, GAN7597RGarces Carlos A · Springfield, VAN7597VMulligan Shawn P · Santa Rosa, CAN7597XPlain Company Ltd · Bloomfield Hills, MIN75982Schurr Frank J · Las Vegas, NVN75985Pitt Patrick L · Ephrata, WAN7598FDoggett Jacob R · Kingwood, TXN7598GGbc Leasing LLC · Gun Barrel City, TXN7598JShutt Ervin F · Bennettsville, SCN7598PBurton Channing L · League City, TXN7598WSmith Cameron · Billings, MTN7599CHurd Air LLC · Sioux Falls, SDN7599FN7599f LLC · Camarillo, CAN7599GJones James D · Linden, NCN7599HMorris Sid · Kenai, AK
Back to AD 81-18-04 R2