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.
N7526DShevock Frank C Jr · Sidman, PAN7526FMikulich Joseph · Bovey, MNN7526GFoothill Aircraft Sales & Service Inc · Upland, CAN7526JWings Over Texas Holdings LLC · Denton, TXN7526LPcm Aviation LLC · Wilmington, DEN7526PSpitzer Helicopter LLC · Woodland Hills, CAN7526WWensel Tyler · North Dinwiddie, VAN75270Long Island Aviators LLC · Seaford, NYN75274Ascent Aviation Inc · Van Nuys, CAN75276Southern Aircraft Consultancy Inc Trustee · Casper, WYN75277Columbus Paul S · Laguna Beach, CAN75278Jmo Aviation LLC · Oakland, CAN7527FProtsman Bryan D · Anchorage, AKN7527GBatista Caleb · Danese, WVN7527HBauer Dereck · Clinton, UTN7527JOlivia Lawrence J · Memphis, NYN7527LChop Air LLC · Natchez, MSN7527PWhite Andrew D · Covelo, CAN7527RTimms Paul E · Collierville, TNN7527WKern David H · Mulberry, FLN75282Aero-Mobil Inc · Wilmington, DEN7528FRausch Bruce Thomas · Marysville, OHN7528GSale Reported · Rillito, AZSale reported, pending cancellationN7528JKlevorn Edward D · Lake Saint Louis, MON7528LThompson Helicopters LLC · Uvalde, TXN7528PGrizzly Skins Of Alaska Inc · King Salmon, AKN7528RLange Kyle W · Mertzon, TXN7528UAg Ranch Services LLC · Lewistown, MTN7528WMy Bird Is Bigger Than Yours LLC · Fort Myers, FLN7528YSkyward Solutions Inc · Lewes, DEN7528ZCastor Aviation Ltd · Ketchikan, AKN75290Barfield Daniel Malcolm · Cartersville, GAN75292N75292 LLC · Statesville, NCN75293N75293 LLC · Pembroke Pines, FLN7529PEmerald City Aircraft Leasing Inc · Port Orchard, WAN7529RRoberts Chad Alexander · Lakeport, CAN7529WWitty Paul R · Delaware, OKN7529ZNielsen Aircraft Corp · Los Angeles, CAN752BGOborny Alan R · Choteau, MTN752CFAnytime Flights LLC · Scottsdale, AZN752DDElmore Scott · Campo, CON752DEEwers C Donald Trustee · Batavia, OHN752DWFlying Start Aero Services LLC · Reno, NVN752ECAll Planes & Helicopters Corp · Pompano, FLNon-citizen corporation, flight hours not reportedN752EREmbry-Riddle Aeronautical University Inc · Prescott, AZN752KFYoung Dale Robert · Springfield, ORN752KSTaffet Jay · New Orleans, LAN752NDUnd Aerospace Foundation · Grand Forks, NDN752RASmtm Holdings Inc · Wilmington, DEN752WGarcia Clint J · Monterey Park, CA
Back to AD 81-18-04 R2