AD 2016-20-06
Registered aircraft · 453
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-20-06')
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-20-06')
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-20-06') 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-20-06') 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.
N613GFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN616CCWest Texas Holdings LLC · San Antonio, TXN616RRRed River Aircraft Leasing LLC · Anchorage, AKN619AAvire LLC · West Hollywood, CAN619MLSmb G-IV Xii LLC · Longwood, FLN623JLJomar Aviation LLC · Boca Raton, FLN624GJBlue Water Aviation LLC · Wilmington, DEN624PDAries Equipment Leasing LLC · Los Angeles, CAN63ESNiceair LLC · Polson, MTN63NMN790cj LLC · Williamsburg, VAN675RWHighlands Group LLC · Lahaina, HIN685MFSmb G-IV Vi LLC · Longwood, FLN68ALAircraft Engine Lease Finance Inc · Guaynabo, PRFirst renewal noticeN69FPPatten Air LLC · Fort Lauderdale, FLN700FJBizav Aircraft Management LLC · Fort Lauderdale, FLN700NYFour M Aviation LLC · White Plains, NYN700SGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN701DBKenmore Crew Leasing Inc Trustee · Bellingham, WAN702GHSej Air LLC · Beverly Hills, CAN702JFJ F Air LLC · Beverly Hills, CAN702LTKruse Capital Partners LLC · Huntsville, ALN704SGJones Aviations LLC · Lexington, MAN705KBRegistered aircraftN707VVAb Jet Co V LLC · Metairie, LAN707WESofi Air LLC · Roslyn Heights, NYN70LNMassachusetts Institute Of Technology · Lexington, MAN710CFCalspan Corp · Niagara Falls, NYN710MVTailspin Management LLC · Los Angeles, CAN711UFDodson International Parts Inc · Rantoul, KSN711WRLaxmi Jet Holdings LLC · Miami Beach, FLN714DSPhoenix Air Group Inc · Cartersville, GAN7176S403tb LLC · Dover, DEN717JCRees Aviation LLC · Rockingham, NCN719SASr Administrative Services LLC · Van Nuys, CAN71BDBdj Aviation LLC · Ridgeland, MSN71NEIal Corp · Lewes, DEN71TV1430 Giv LLC · Fort Lauderdale, FLN720ADTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN721BSAria LLC · Salt Lake City, UTN721CFCalspan Corp · Buffalo, NYN721CNUnited Trading Unlimited LLC · Coconut Grove, FLN722NKOsprey Wings LLC · Las Vegas, NVN726RWAvire LLC · West Hollywood, CAN729TYDelaware Aircraft Trust LLC Trustee · New Castle, DEN741VETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN746MNSparta Aviation Group LLC · Loveland, OHN748MNOnpoint Avionics LLC · Downey, CAFirst renewal noticeN74AMissile Defense Agency (Mda) · Tulsa, OKN74GGDwm Logistics LLC · San Luis Obispo, CAN74RTState Technical College Missouri · Linn, MO
Back to AD 2016-20-06