AD 2011-06-10
Registered aircraft · 998
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-06-10')
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-06-10')
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-06-10') 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-06-10') 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.
N26TGKenmore Crew Leasing Inc Trustee · Bellingham, WAN274CFair18 LLC · Montgomery, ALN276JKGfk Investments LLC · Saint Joseph, MIN27RZHq Wings LLC · Porterville, CAN2808LNtss LLC · Henderson, NVN280KCMccarty Anthony O · Saint Augustine, FLN280KTGetchell Investments LLC · Dallas, TXN283SSSmith Scott R · Grand Junction, CON286CMB&K Aircraft Leasing LLC · West Plains, MON288TGSky West Aviation Inc Trustee · Albuquerque, NMN28BRFlying Rock Aero LLC · Sunnyvale, CAN28JKTorps LLC · Southlake, TXN28KYSoldo Joseph Peter · Chattanooga, TNN295SKds Aviation LLC · Normal, ILN296PCCarlyle Air LLC · Morristown, TNN297CLivestock Health Products-Texas Inc · Dalhart, TXN297PMCentral City Aviation LLC · Carrington, NDN29KETj Air Holdings Inc Trustee · Wilmington, DEN302MMHidden Springs Aviation LLC · Perryville, KYN304LAK2 Sales LLC · Idaho Falls, IDN306YSFlamingo Aircraft Holdings LLC · Orlando, FLN3095GLas Piedras LLC · Englewood, CON3098NValiair Lc Trustee · Casper, WYN309HWWolfe Rentals LLC · Milwaukie, ORN310BUTar Heel Aviation Inc · Bonita Springs, FLN310EMTc Aviation LLC · Atlanta, GAN311JFGrowers LLC · Mohall, NDN311KFAlpha Papa LLC · Fort Stockton, TXN311LGCorporate Aviation Partners I LLC · Fort Worth, TXN3131MAir Service LLC · Wilmington, DEN3134FSignature Aviation Group LLC · Columbia, MON314PLWkj Enterprises LLC · Boulder, CON3151GMtc Aviation LLC · New Harmony, UTN316KUOldenburg Air LLC · Henderson, NVN316TGTutton Group LLC · Jasper, GAN317GCGospel Carrier International Inc · North Potomac, MDN318CWHeronimus Kevin A · Lebanon, TNN319RDN319rd LLC · Casa Grande, AZN319UWebb Automotive Group Inc · Farmington, NMN31BXWhite Robert · Woodlawn, TNN321AGLeo Air LLC · Marietta, OKN322MEMast Enterprises Equipment LLC · South Boston, VAN323FLSch Aviation Inc Trustee · Sporle Kings LynnN325MRDv Group LLC · Clovis, CAN327MZWdl/Oracle LLC · Tucson, AZN328EMConcierge Diamonds Inc · Los Angeles, CAN329KSWings Flights Of Hope Inc · Orchard Park, NYN329TTJsh Aviation LLC · Dover, DEN330HTPhelan Dennis M · Goodyear, AZN333GCDlx Rzl LLC · Rensselaer, IN
Back to AD 2011-06-10