AD 2016-10-16
Registered aircraft · 717
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-10-16')
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-10-16')
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-10-16') 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-10-16') 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.
N225GLRunway Rouge LLC · Baton Rouge, LAN22NFSunwest Aero LLC · Dallas, TXN232EZCrest Operations LLC · Pineville, LAN233KCMp Air LLC · Eagle Point, ORN236LXWilmington Trust Co Trustee · Delaware, DEN237BBBaron & Budd P C · Dallas, TXN239AXAviation8 LLC · Carle Place, NYN23BEBenjamin Partners LLC · Wilmington, DEN23SMSam & Sam3 Consulting LLC · Scottsdale, AZN243CF2bar Aviation LLC · Denver, CON246AGBank Of Utah Trustee · Salt Lake City, UTN247EZCjl Aviation LLC · Pinellas Park, FLN247FRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN247WDNgl Aviation Den LLC · Denver, CON248BTDelsey LLC · Newport Beach, CAN248LXHaus Of Suss LLC · Dallas, TXN250JCProspectpb LLC · Wilmington, DEN250LPMetta 2000 LLC · Dorado, PRN2511BDealer Equipment Leasing LLC · Miami, FLN252PJFalcon 900ex Msn 52 LLC · New Castle, DEN256RCVulcan Materials Company · Vestavia, ALN25MXAce Parts LLC · Santa Fe Springs, CAN261CHSeecon Builders Inc · Concord, CAN264CDf 254 Holdings LLC · Wilmington, DEN264VFlight Basic Services LLC · Saint Paul, MNN2652Columbia Bank · Lake Oswego, ORN265HTmfb Transporation LLC · Orlando, FLN269PHPruitt Tran II LLC · Norcross, GAN26SMTricor Aviation LLC · Winter Park, FLN271ACTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN272FCBest Aviation Inc · Baldwin, GAN273LXFrist Aviation LLC · Nashville, TNN273SWRegistered aircraftN274SGFree Bird Flight Ops LLC · Newport Beach, CAN275SWRegistered aircraftN278RFGlenbrook III LLC · San Jose, CAN279SWRegistered aircraftN27FJAviation Resource Group Inc · Ft Lauderdale, FLN2828Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN286MJHc Logistics LLC · Chicago, ILN288FATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN28DCMbogo Energy LLC · Boerne, TXN291MJTequila Mockingbird LLC · New York, NYN298RDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN299FGTvpx Trust Co LLC Trustee · North Salt Lake, UTN2NLCenturion Investments Inc · Chesterfield, MON301MTRegistered aircraftN303CLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN303TFNtc Aviation LLC · Greenwich, CTN304KSonic Automotive Inc · Charlotte, NC
Back to AD 2016-10-16