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.
N2201RMize Helicopter LLC · Grand Prairie, TXN2201TCiupitu Marc P · Houston, TXN2202NAlcyone Trust Corp Trustee · Wichita, KSN2202QLewis University · Romeoville, ILN2202UAsp Legacy Holdings Corp · SpringwaterN2202YStanley Aviation LLC · Colby, KSN2203ASs Three LLC · North Platte, NEN2203FElk Flyers Inc · Saint Marys, PAN2203RHubin Scott E · Kent, OHN22044182 Flight Corp · Bronx, NYN2204ATbl Aviation LLC · Meridian, IDN2204TNgugi Samson W · El Paso, TXN2204ULi'L Dawg Aviation Inc · Florence, ALN2204XAirgo Inc · Centralia, ILN22055Adrian Ojeda Jr · San Ysidro, CAN2205FMolzon William R · Irvine, CAN2205MArthur Aircraft LLC · Sparta, ILN2205PSignature Properties Of Litchfield Inc · Murrells Inlet, SCN2205ULighter Aaron S · Buckeye, AZN2206BVolare Aviation LLC · Livingston, NJN2206DLassiter James D · Silas, ALN2206QVandeman Jack · Norco, CAN2206TMullins John D · Bluff City, TNN2208ALance Eight Alpha LLC · Terre Haute, INN2208TThurmond Donald · Madison, GAN2209PRuppel Robert E Jr · New Orleans, LAN2209TSngdo Aviation LLC · Spring Hill, FLN2209VChinn Timothy D · Austin, TXN220AGPlane Fun Inc Tr Trustee · Snellville, GAN220ASHolder Michael T · Whitesburg, GAN220AURunamuck LLC · New Orleans, LAN220BCRock Creek Leasing LLC · Sapulpa, OKN220BDAlexander Nathan D · Melrose, IAN220BLSolera Aviation LLC · Bozeman, MTN220CACivil Air Patrol · Maxwell Afb, ALN220CBNeff Michael J · Laveen, AZN220CEMeridian Aircraft LLC · Wilmington, DEN220CPCivil Air Patrol · Maxwell Afb, ALN220EXRodriguez Henry Solano · Charlotte, NCN220FLChristiansen Aviation LLC · Wilmington, DEN220JGArchies Wings LLC · Umatilla, FLN220JWFirst Eagle Inc · Wilmington, DEN220LLife Chiropractic And Wellness Center Inc · Prudenville, MIN220MGCornwell Anne L · Athens, OHN220MMMiranda Jon · El Dorado Hills, CAN220NXPendley Timothy · Madera, CAN220RBParker Rob · Yukon, OKN220RMBenner Gregory T · Youngsville, NCN220SGExecutive Helicopters Inc · Myrtle Beach, SCN220TAAircraft Partner Holdings Inc Trustee · Berlin
Back to AD 2006-10-21