AD 2011-22-01
Registered aircraft · 1,167
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:2011-22-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-22-01')
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:2011-22-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-22-01') 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.
N703FSFlo-Sun Aircraft Inc · West Palm Beach, FLN703RKEmergence Southwest LLC · Jacksonville, FLN704MFMc Group · Santa Monica, CAN708DSWilmington Trust Co Trustee · Wilmington, DEN708JHUnited States Government · Washington, DCFirst renewal noticeN708TTWilmington Trust Co Trustee · Wilmington, DEN709AABank Of Utah Trustee · Salt Lake City, UTN70PSRi Mercury LLC · Beverly, MAN71111Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN711EGG550 N711 LLC · Newport Beach, CAN711MCN&Md Investment Corp · Missoula, MTFirst renewal noticeN711WKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN712LWWanderweg Holdings LLC · Salt Lake City, UTN715TSTvpx Trust Co LLC · North Salt Lake, UTN716ASAs Aviation Holdings LLC · Wilmington, DEN716GCGreat Clips Inc · Minneapolis, MNN716TVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN717JLDelta Air Lines Inc · Atlanta, GAN717KDSky Range Aviation LLC · Sioux Falls, SDN718DDFlt 2 LLC · Dallas, TXN718JJJj Acquistions 681 LLC · Secaucus, NJN718MCRadical Ventures LLC · Dallas, TXN718PMConfectionery Advantage LLC · Park Ridge, NJN720LETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN720WLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN721AZSz Aviation LLC · Miami, FLN721KJBank Of Utah Trustee · Salt Lake City, UTN721MCCsc Delaware Trust Co Trustee · Wilmington, DEN721MMMandalay Resort Group LLC · Las Vegas, NVN721MSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN721RHRh · Wilmington, DEN723HAHagan Properties Inc · Louisville, KYN723HHAircraft Trust & Financing Corp Trustee · Wilmington, DEN724JJKoga Air LLC · San Luis Obispo, CAN724MFMbf Leasing Of Florida LLC · Coral Gables, FLN726AFBank Of Utah Trustee · Salt Lake City, UTN726BFWilmington Trust Co Trustee · Wilmington, DEN727PRCorporate Wings LLC · Cleveland, OHN727SJDataone Systems LLC · Dallas, TXN727TEMillrock Aviation Financial LLC · Danbury, CTN728ECChouest Air Inc · Cut Off, LAN730BCDelta Air Lines Inc · Atlanta, GAN730DDDpm Aviation LLC · Dover, DEN731SR83/80 LLC · New York, NYN73RPTransportation Holdings IV LLC · Dallas, TXN73ZZGlobal Aircraft II LLC · Eden Prairie, MNN740SS740ss LLC · Tooele, UTN7413BTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN74DHHalbert & Associates LLC · Irving, TXN74VZRegistered aircraft
Back to AD 2011-22-01