AD 2001-20-07
Registered aircraft · 298
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:2001-20-07')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-20-07')
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:2001-20-07') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-20-07') 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.
N307MTAlcyone Trust Corp Trustee · Wichita, KSN308JRSummit Aero Holdings Corp · Wilmington, DEN308KPK&P Aviation LLC · Saint Petersburg, FLN311HSSteck Aviation LLC · Mineola, TXN311JVAcme Leasing LLC · Nashville, TNN312GKHoly Spirit LLC · Haleyville, ALN315RTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN317PCCh Aircraft LLC · Palm Beach, FLN318KSVaerus Jet Sales LLC · Topeka, KSN330RSmytheair LLC · Newburgh, INN332AVSancon Leasing LLC · Nashville, TNN33BLLot Equipment LLC · Baton Rouge, LAN3438Imeca Jet LLC · Miami Gardens, FLN346HGReal Logistics LLC · Greenville, SCN349FJFlying Aceholes LLC · Amarillo, TXN375DTAhj Hawk Aviation LLC · Bonita Springs, FLN379RKAdams Aviation Services Inc Trustee · Wilmington, DEN387LSBeech Transportation Inc · Eden Prairie, MNN38TPBank Of Utah Trustee · Salt Lake City, UTN390SB400xp Shares LLC · Liberal, KSN397MGAviation Trust Company LLC Trustee · Oklahoma City, OKN400ALN400al Leasing LLC · Wichita, KSN400AXN400ax Leasing LLC · Wichita, KSN400BHBbh Partnership LLC · Topeka, KSN400CNTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN400DCRk-250 Leasing LLC · Wichita, KSN400DGN400dg Leasing LLC · Wichita, KSN400DLN400dl Leasing LLC · Wichita, KSN400DXN400dx Leasing LLC · Wichita, KSN400FFN400ff Leasing LLC · Wichita, KSN400JDN400jd Leasing LLC · Wichita, KSN400KPCentral Iowa Aviation LLC · Ankeny, IAN400LCN400lc Leasing LLC · Wichita, KSN400LGBeechjet Shares LLC · Wichita, KSN400LZN400lz Leasing LLC · Wichita, KSN400MDPdii LLC · Concord, NCN400MKNorth Star Companies Inc · Mankato, MNN400MVDsi Aviation Inc · Wichita, KSFirst renewal noticeN400MXRjb Management Company Inc · Moon Township, PAN400PKN400pk Leasing LLC · Wichita, KSN400PVRk-263 Leasing LLC · Benton, KSN400RGN400rg Leasing LLC · Wichita, KSN400RYRegistered aircraftN400SMN400sm Leasing LLC · Wichita, KSN400TCMorning Star Aviation LLC · Indianapolis, INN400TUN400tu Leasing LLC · Wichita, KSN400VPN400vp LLC · Wilmington, DEN400WFTwo Rivers Aviation LLC · Wichita, KSN400XClemens Aviation LLC · Wichita, KSN400XAN400xa LLC · Wichita, KS
Back to AD 2001-20-07