AD 2006-10-21
Registered aircraft · 44,908
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:2006-10-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21')
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:2006-10-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21') 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.
N2192PSandoval Tax Cpas Inc · Bakersfield, CAN2192TMazza Frank · Bridgeton, NJN2193GWestward Aviation · Boulder, CON2193VApm Leasing LLC · Casper, WYN2193WAzalea Utilities Inc · Summerville, SCN2194KAviation Training LLC · Wilmington, DEN2194LState Of Wisconsin · Madison, WIN2194TNelson Donald M Jr · Fair Oaks, CAN2195EZameroski Daniel C · Mckean, PAN2195LGinsberg Andrew P · Rochester, NYN2195MKorba Sean · San Jose, CAN2196LAerolisse LLC · Chouteau, OKN2196NThompson Kurt C · Rochester, MNN2196SHernandez Christopher A · Phoenix, AZN2196TTilly Curtis L · Raleigh, NCN2196UZeiner Gary R · Greencastle, INN2196VFixed Wing Holding Co Inc · Pembroke Pines, FLN2197TAdams Donald L · Huntsville, ALN2197XKelley Brian S · Vancouver, WAN21985N21985 LLC · Deltona, FLN2198PAerotrack Inc · Hemet, CAN2198SPeavey Brian H · Houston, TXN21992Gilpin Sean F · Madison, ALN2199TKeith Brothers Aviation LLC · Fort Worth, TXN219AMeridian Aircraft LLC · Wilmington, DEN219CACivil Air Patrol · Maxwell Afb, ALN219CDCd Flyers LLC · Port Orange, FLN219DL3 Wolfpack Sigma LLC · Overland Park, KSN219DBN219db LLC · Bryan, OHN219DCMjz Ventures LLC · Dodge City, KSN219DGCtrl Electrical LLC · Lexington, NCN219DSJojo & Dino Ltd · Frederick, MDN219EAMusante Keith · Heber City, UTN219EPEpic Aviation Inc · New Smyrna, FLN219JRRoberts Pipeline Inc · Middletown, INN219LELeading Edge Aviation Inc · Bend, ORFirst renewal noticeN219MCHansen Todd · Friday Harbor, WAN219PBChoptera LLC · Odem, TXN219PDWolfair LLC · Lewes, DEN219RTSky West Aviation Inc Trustee · Albuquerque, NMN219SDFreund Gregor · San Francisco, CAN219SPLouisville Aircraft Leasing LLC · Louisville, KYN219WEFinnegan Dennis M · Novato, CAN219WYWolding Mylo · New Town, NDN21ABAriel J Quintela LLC · Odessa, FLN21AGGronemeyer Jens · Deland, FLN21AJAllcroft Roger A · Haydenville, MAN21AQCapiga Daniel P · North Fort Myers, FLN21ARClarkson Jeffrey D · Park Rapids, MNN21ASBoa Properties LLC · Valdosta, GA
Back to AD 2006-10-21