AD 2012-10-13
Registered aircraft · 13,306
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:2012-10-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-10-13')
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:2012-10-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-10-13') 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.
N767BCCambata Aerospace LLC · Millboro, VAN767BKF&E G A Inc · Miami Springs, FLN767CMValiair Lc Trustee · Casper, WYN767DFMaurin Edward E III · Grand Junction, CON767EMGoepfert Lease Company LLC · Joplin, MON767JPPicard Philip A · Clover, SCN767JRAzure Aviation LLC · Mount Pleasant, SCN767PLFly Girls LLC · La Verne, CAN767RRRed Leasing LLC · Juneau, AKN767SBRegistered aircraftN767WTO'Dell Thomas Anthony · Sunnyvale, CAN767ZZRegistered aircraftN768CBDk Air LLC · Encino, CAN768CDSears William R · Lexington, MAN768FSRegistration Pending · Fruita, CORegistration pendingN769ACAircraft Propulsion Leasing LLC · Holland, OHN769CDSutherland James N · Terrebonne, ORN769EAHyannis Air Service Inc · Hyannis, MAN769KVFalcon Aviation Inc · West Jefferson, OHN769SROwll Aviation LLC · Baton Rouge, LAN769TXRegistration Pending · Henderson, NVRegistration pendingN76ALAldeen Leo · Houston, TXN76BLBravo Lima Corp · Lakewood, CON76BYViper Aeronautics LLC · Lincoln, NEN76CETri Gen Air LLC · Bedford, VAN76CWYatahey LLC · Middletown, DEN76DFMtb Aviation LLC · Ormond Beach, FLN76DWNuage Nine Inc Trustee · Wilmington, DEN76KTWarriors With Wings LLC · Zebulon, NCN76LKAir Supply Inc · Clearwater, FLN76MJJzw Aviation LLC · North Salt Lake, UTN76SVParish Aviation LLC · New Orleans, LAN76VVVandersteen Richard J · Hanford, CAN7702QRobinson Meyer · Daphne, ALN770CAHorse Hill LLC · Napa, CAN770CFKopp Adrian D · Brookville, INN770CTMetza M Kristen · Andrews, NCN770MMButterworth James Blakely · Demorest, GAN770SRRiverside Aircraft LLC · Fort Myers, FLN770TPJekkerson LLC · Evergreen, CON770ZZInternational Air Services Inc Trustee · Carson City, NVN7711GTrans Meridian LLC · Fort Myers Beach, FLFirst renewal noticeN7719QTurel Stanley · Bend, ORN771BB406 Mountain Air LLC · Bigfork, MTN771BTRosen Air 71 LLC · Brentwood, TNN771EAHyannis Air Service Inc · Hyannis, MAN771FRDellinger Aero Inc Trustee · Wilmington, DEN771KSWieczorek Michael A · Athens, GAN771MPFl072 Aviation LLC · Brentwood, TNN771SL3vr Aviation LLC · Annapolis, MD
Back to AD 2012-10-13