AD 94-05-05 R1
Registered aircraft · 26,228
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:94-05-05-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1')
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:94-05-05-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1') 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.
N11243Aeronautical Technical Service Inc · Collierville, TNN1124HNolan Robert C II · Las Vegas, NVN1124QDuren Virgil W · Bristow, INN11251Air Flight Enterprises Inc · S Daytona, FLN11257Sale Reported · Eden Prairie, MNSale reportedN1125DStarr Eric M · Queen Creek, AZN1125FAeropark LLC · Michigan City, INN1125HClark David D · Nenana, AKN11262Locke Brian T · Andover, KSN11268Bohl Howard M Jr · Long Beach, CAN1126DHynds Michelle S · Addison, TXN11272Williamson Brett O · Essex, MON1127FPricemeyer Aviation LLC · St Pete Beach, FLN1127NPiercy Ronalds · Moses Lake, WAN1127YWong David · Torance, CAN11281Solovjev Jadranka · Sarasota, FLN11283J F Aviation Inc · Joliet, ILN11285Northeast Florida Aero Club Inc · Fleming Island, FLN11289Phelps Aero Co LLC · Salem, ORN1128FLockridge James · Adairsville, GAN1128YPerez Donna · Chico, CAN11290Safety In Motion Flight Center Inc · Puyallup, WAN11295Bancroft David J · Rio, WIN11297Raley James C · Brandon, SDN11299Creech John M · Brentwood, TNN1129DKogl John L · Valparaiso, INN1129FKoch Bradley D · Billings, MTN1129MTechair LLC · Playa Vista, CAN112LNBruce James W · Searcy, ARN112NBillingsley Carl · Henderson, TXN112NBCarew Enterprises Inc · Appleton, WIN112QBFloyd Austin · Searcy, ARN112RPTaylor Chad A · Enid, OKN112TLutsko Duane · Woodstock, MDN11305Logsdon Elizabeth M · Morganfield, KYN11308Kaher Kevin G · Menlo Park, CAN1130FMonahan William T · Vestal, NYN1131HLeisner David L · Palmer, AKN11322Creekside Speech Therapy LLC · Ocala, FLN11323Huckabay Timothy J · Red Bluff, CAN11329Burkhart Verlus L · Fairmont, MNN1132HWallis Frederick W · Healy, AKN11331Gervais Andre B · Griffin, GAN11332Byrd Craig Stephen · Laurel, MSN11337Harris Hayden H · Chelsea, MIN1133DBohl Howard M · Temecula, CAN1133ESpear Marie C · Salem, WIN1133FFinnelly Barry J · Snohomish, WAN1133MRobinson Lanis A · Clanton, ALN1133YGreen Mountain Semiconductor Inc · Burlington, VT
Back to AD 94-05-05 R1