AD 2016-05-13
Registered aircraft · 3,126
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:2016-05-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:2016-05-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:2016-05-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:2016-05-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.
N68BJCrownair LLC · Mansfield, PAN68TFRegistered aircraftN69Federal Aviation Administration · Oklahoma City, OKN690CKlass Investments LLC · Marksville, LAN690MAAviation Inventory Resources Inc · Alvarado, TXN690MFDesert Sand Aircraft Leasing Co Inc · Rosharon, TXN6925YPleasant Aviation LLC · Mount Pleasant, TXN692ABBank Of Utah Trustee · Salt Lake City, UTN692DADirect Action Aviation LLC · Reno, NVN692MPWoodley Aerial Leasing LLC · Walnut, ILN694DADirect Action Aviation LLC · Reno, NVN695LAMurphree Flying Service Inc · Crystal Beach, TXN695STKraemericair LLC · Saint Louis, MON697PStaker & Parson Co · Ogden, UTN699BWBeech Transport LLC · Tarboro, NCN699CCC & C Market Research Inc · Fort Smith, ARN699SAAircraft Guaranty Corp Trustee · Oklahoma City, OKN699TPDoodle Aviation LLC · Burlington, NCN69FYTexoma Ag LLC · Corsica, SDN69VCPro Agri Spraying Service Inc · Ropesville, TXN69XZJtac Systems LLC · Leonardtown, MDN6FZZebra Air Adventures LLC · Atlanta, GAN6VAMidstates Aircraft Leasing LLC · Bern, KSN6VJN6vj LLC · Coleman, FLN7001CThrush Aircraft LLC · Albany, GAN70058Thrush Aircraft LLC · Albany, GAN700ANAi Kinetics LLC · Los Altos, CAN700APSutton Bay Leasing LLC · Excelsior, MNN700AYKellman Act Services Inc · Pacific Palisades, CAN700BNBostic Capital Group LLC · Prestonsburg, KYN700BSPark Rapids Avionics Inc · Park Rapids, MNN700CFN7880l LLC · Port Charlotte, FLN700CSSocata 109 Inc Trustee · Wilmington, DEN700CTPatriot Contractors LLC · North Las Vegas, NVN700CVIlmo Adventures LLC · Kalispell, MTN700CZNexus Surgical Innovations Inc · Bozeman, MTN700DEPhoenix Trailers Aviation LLC · East Jordan, MIN700DTNorth Coast Ventures LLC · Wilmington, DEN700EBEcho Bravo LLC · Geneva, ILN700ELAir Twinlite Inc Trustee · Wilmington, DEN700ERBa Transportation Inc · Colonial Heights, VAN700FXFederal Express Corporation · Memphis, TNN700GJRockland Key Aviation Inc · Wilmington, DEN700GNTinman LLC · Raleigh, NCN700HKDsl LLC · Las Vegas, NVN700HNHartman Doyle · Aspen, CON700HYClear Blue Sky Aviation LLC · Hilton Head Island, SCN700JJIndependent Monitoring LLC · Los Altos, CAN700LLGf Air LLC · Las Vegas, NVN700LXLimpia Logistics LLC · Midland, TX
Back to AD 2016-05-13