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.
N137VUPerformance Aircraft Sales Inc · Lincoln, NEN137WWuorinen William J · Inver Grove Htgs, MNN13803Crociati Douglas R · Plymouth, MAN13804Henderson Jeannie · Colorado Springs, CON1380JCole Dianne L · Groveland, CAN1380TN1380t LLC · Wilmington, DEN1380WOverstreet Jeffrey D · Bentonville, ARN13817Conroy Philip L DBA · Colleyville, TXN13819Avco Patrol LLC · Lyndon, KSN1381CEagle Sky Patrol Inc · Deadwood, SDN1381WReed Michael S · Sweetwater, OKN1382Air Cowboy LLC · Roca, NEN13832Davey Spencer J · Spokane, WAN13839Tyler Petroleum Inc · Tyler, TXN1383JEpic Partners LLC · Keizer, ORN1384CRedwood Area Flyers LLC · Redwood Falls, MNN1384WTz Aviation LLC · Enterprise, ALN1385TRayfield Charles · Downingtown, PAN1385ZWilson Tommy V · Greenleaf, IDN13862Reliance Island Inc · Wilmington, DEN13865Enzed Aviation Services LLC · Anchorage, AKN1386HRodriguez Luis D · Davenport, FLN1386JO'Neal Christopher Gage · Baton Rouge, LAN13882Gc Aviation Services-1 LLC · Miamisburg, OHN1388TNora Jet LLC · Granbury, TXN1388WM30c 2666 LLC · Jenks, OKN13892Meyers Alexander C · Pittsburgh, PAN1389BColumbia Safety Medical LLC · Kennewick, WAN1389JKaminski Joseph F · Port Richey, FLN1389TR And S Flying LLC · Westfield, MAN138ABAerial Banners Inc · Pembroke Pines, FLN138ACZimmerman Gerald M · Savannah, GAN138AZTablemax Aeronautics LLC · El Paso, TXN138BCUniversidad Interamericana De Puerto Rico · Bayamon, PRN138BLSolera Aviation LLC · Bozeman, MTN138CCRig Air LLC · Alamogordo, NMN138DWHassell Charles W · Hendersonville, TNN138FCUsda Forest Service Fepp · Tallahassee, FLN138GBBurgan Grover W · Jacksonville, FLN138JPChang Denny · Easton, PAN138LGRocket Aero LLC · Addison, TXN138LWIsland Air Charters Inc · Ft Lauderdale, FLN138MEA&R Aero LLC · Sacramento, CAN138RA & K Aviation LLC · Wenatchee, WAN138RJBayou Flight Training LLC · Niceville, FLN138UDAb Prop Plane II LLC · Metairie, LAN138VAMysky LLC · Saint Louis, MON138WSGardner Luther Winford III · Dallas, TXN13901Masscotte Michael · Mansfield, MAN1390TAccessible Aviation Inc · Tupelo, MS
Back to AD 2006-10-21