AD 2016-19-13
Registered aircraft · 960
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-19-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-19-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-19-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-19-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.
N900KWAlta Airlines Holdings LLC · Salt Lake City, UTN900LCMid Central Leasing LLC · Waukegan, ILN900LNLd Services LLC · Pasadena, TXN900LPDoctair Inc · Mclean, VAN900LWMnw Aviation LLC · Midland, TXN900MKRacer X LLC · Chicago, ILN900MWGlobal Jet Partners LLC · Scottsdale, AZN900NHNew Mfis Holdings LLC · Henderson, NVN900NTNovember Tango Aviation LLC · West Fargo, NDN900PNBank Of Utah Trustee · Salt Lake City, UTN900RLEib Equipment Leasing LLC · Naples, FLN900SBBg Air LLC · Hobbs, NMN900SETmt Aviation LLC · Wichita Falls, TXN900SFFalcon 900 LLC · Mount Laurel, NJN900SLLima Tango Leasing Inc · Wichita, KSN900SNSn117 LLC · Great Neck, NYN900TEFalcon 900 LLC · Ocala, FLN900TNRegistered aircraftN900VCFalcon-121 LLC · Salem, ORN900VGVecellio Management Services Inc · West Palm Beach, FLN900VLWilmington Trust Co Trustee · Wilmington, DEN900VPJdr 194 LLC · Woody Creek, CON900WGGreenleaf Corp · Saegertown, PAN900WKRegistered aircraftN900XYArchitectural Air II LLC · Washington, DCN900YBBold Access LLC · Leawood, KSN900YGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN900YPVillages Equipment Co · Leesburg, FLN900YYBbps Aviation LLC · Mckinney, TXN901FHCcbcc Operations LLC · Charlotte, NCN901KRAvatar Wings LLC · Dallas, TXN901MMUsonia Ventures LLC · Palo Alto, CAN902ABAngel Brothers Enterprises Ltd · Baytown, TXN902AMBslcc-III LLC · Renton, WAN902JJetran LLC · Horseshoe Bay, TXN902TFTyson Shared Services Inc · Springdale, ARN902YPVillages Equipment Co · Leesburg, FLN904NBNewell Brands Inc · Atlanta, GAN904RMAer Sales Lp · Carrollton, TXN904YPVillages Equipment Co · Leesburg, FLN905BTvpx Trust Co LLC Trustee · North Salt Lake, UTN905FJTvpx Trust Co LLC Trustee · North Salt Lake, UTN905YPVillages Equipment Co · Leesburg, FLN908SBFalcon Hunter LLC · Houston, TXN909CKDodson International Parts Inc · Rantoul, KSN909JMRegistered aircraftN909MMNalpak Consulting LLC · Santa Monica, CAN909NFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN90BBBank Of Utah Trustee · Salt Lake City, UTN90FJWorldwide Aircraft Services Inc DBA · Tampa, FL
Back to AD 2016-19-13