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.
N880ECDodson International Parts Inc · Rantoul, KSN880PCPromega Corp · Madison, WIFirst renewal noticeN880VJAce Listenger Enterprises LLC · Louisville, KYN881ADDna Air LLC · Wilmington, DEN881CECeoc LLC · Las Vegas, NVN882ADDna Air LLC · Wilmington, DEN883CECeoc LLC · Las Vegas, NVN883RAGhk Aviation LLC · Oklahoma City, OKN884BBHf III LLC · Saint Paul, MNN884BNTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN887CECeoc LLC · Las Vegas, NVN8888Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN888FCBank Of Utah Trustee · Salt Lake City, UTN888NAIdeavillage Products Corp · Wayne, NJN888WLAir Sare One LLC · Delray Beach, FLN888ZAJhb Aviation LLC · New York, NYN889HHoneywell Aerospace US LLC · Phoeni, AZN889MUGf Aircraft LLC · Tampa, FLN889TDEasy Leasing LLC · Greenwich, CTN88DDRegistered aircraftN88GDKamali Aviation LLC · Great Neck, NYN890BBNew Heights LLC · Saint Paul, MNN890CLN890cl LLC · Wheeling, ILN890LTLife Time Inc · Chanhassen, MNN890PSLbma Equipment Services Inc · Newburgh, NYN895MMRegistered aircraftN897DWarbler I LLC · Freeland, MIN8989BCloud Cruiser II LLC · Minneapolis, MNN899BCThabit Holding Co LLC · Sherman Oaks, CAN89AAFsr Racing LLC · Santa Rosa Beach, FLN89PMid-Atlantic Aviation V LLC · Saint Petersburg, FLN89RPRich Aviation Inc · Buffalo, NYN89RTRegistered aircraftN89TVBqn Flights Corp · San Juan, PRN8SBSb Air LLC · Winchester, VAN900BBNical Aviation LLC · Austin, TXN900BKRck Aviation LLC · Woodside, CAN900CQCequel III LLC · Saint Louis, MON900DTega Air LLC · Bend, ORN900EBSubaru Of New England Inc · Norwood, MAN900EEIrish Air II LLC · Cincinnati, OHN900EFHarrison Rosemary J · Houston, TXN900ERJdr 192 LLC · Woody Creek, CON900EUBank Of Utah Trustee · Salt Lake City, UTN900FJEmmanuel Group · North Wilkesboro, NCN900HDNical Aviation LLC · Austin, TXN900HGBohlke LLC · Kingshill, VIN900JFFerrer Air LLC · Dallas, TXN900KRAvatar Wings LLC · Dallas, TXN900KUFalcon 900-91 LLC · Lewes, DE
Back to AD 2016-19-13