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.
N1410Swe3 LLC · Seattle, WAN1410EGulf Atlantic Airways Inc · Gainesville, FLN1411Grubb Logan · Faulkton, SDN1411JSimmons John W · Ocala, FLN1411TCable Marsha A · Toronto, OHN1411ZGrindeland Edson M · Hatton, NDN14133C I Holdings Ltd Inc · Lewes, DEN14135Olympiakh LLC · Louisville, KYN14138Island Bound LLC · Dunedin, FLN14149Ninja Turtle LLC · Orlando, FLN1414TThomas Evan C · Lancaster, CAN1415JSale Reported · Irving, TXSale reportedN1415XLaramee Michael E · Goldsboro, NCN14175Box Aviation Inc · Montgomery, ALN14183Osborne Donald R · Fairbury, NEN1418ABay Ronald · Hunt Valley, MDN1418JAaa Training LLC · Kalispell, MTN1418RHall James E · Shalimar, FLN1418TZucchi Steven · Ephrata, PAN1418XHaskin Kent B · Claverack, NYN1419CVetrone Troy · Wisconsin Rapids, WIN1419DAir America Flight Center LLC · Daytona Beach, FLN1419FAir Callahan LLC · Bonita Springs, FLN1419TBrolan Aviation LLC · Kansas City, MON1419XWhitman Aviation LLC · Morganville, NJN141AAHeavy Metal Air LLC · Farmingdale, NYN141AFSmith Michael J · Brandon, MSN141ANWells Ryan · Holdrege, NEN141AREpp Robert Jackson · New Kent, VAN141AVMavity Michael D · Phoenix, AZN141BHBob Hannah Aviation LLC · Caldwell, IDN141CDSky Helicopters Inc · Desoto, TXN141CHRegistered aircraftN141CLFulbright Charles M · Toccoa, GAN141CMMoran Christopher C · Colleyville, TXN141DDCox Aviation Services LLC · Acworth, GAN141FAnderson Jon J · Hill City, SDN141FCDepartment Of Agriculture & Consumer Services · Tallahassee, FLN141FQCross Daniel · Windham, NHN141FWSchultz Frank R · Lafayette, CON141MEFox Heather J · Bettles Field, AKN141NCheney John A · North Baltimore, OHN141PNational Test Pilot School · Mojave, CAN141RBClevenger Glen D · Cottage Grove, ORFirst renewal noticeN141RSFrederick Investment Corp · Raleigh, NCN141SBCk Aviation LLC · Bismarck, NDN141SEHydro Flyers LLC · Woodside, CAN1420N5504r LLC · Jefferson City, MON14202Hodge Uriel · St Thomas, VIN14207Belk William E · Labelle, FL
Back to AD 2006-10-21