AD 2003-13-10
Registered aircraft · 1,011
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:2003-13-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:2003-13-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:2003-13-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:2003-13-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.
N14807Hammock Flying Service Inc · Smithville, ARN148AWAircraft Trustee Services Inc Trustee · Dover, DEN149PDAdministracion De Los Servicios Generales · San Juan, PRN14HXHelicopter Express LLC · Chamblee, GAN150AMAir Methods LLC · Greenwood Village, CON152AMAir Methods LLC · Greenwood Village, CON153PAGm Leasing Company LLC · Broussard, LAN155TVU S Helicopters Inc · Marshville, NCN157BAAirmart Inc · Lexington, KYN158ABBell Textron Inc · Fort Worth, TXN15MXBank Of Utah Trustee · Salt Lake City, UTN160AMAir Methods LLC · Greenwood Village, CON1612Gm Leasing Co LLC · Broussard, LAN163RLRotorcraft Leasing Company LLC · Broussard, LAN165SPSouthern Utah University · Cedar City, UTN168TBSouthwest Aviation Enterprises · Haslet, TXN169RLRotorcraft Leasing Co LLC · Broussard, LAN16SPState Of New York · Albany, NYN17238Bennett Aviation LLC · Lafayette, LAN173MSFlorida Keys Mosquito Control District · Marathon, FLN173RLRotorcraft Leasing Co LLC · Broussard, LAN173SFGm Leasing Company LLC · Broussard, LAN173SJAnthony Ghidossi Chemical LLC · Marysville, WAN175HAShearer John · The Dalles, ORN175JKJk Aviation LLC · Kerman, CAN176ETSan Juan Aviation LLC · Wilmington, DEN179RLRotorcraft Leasing Co LLC · Broussard, LAN179SFN179sf LLC · Chandler, AZN17DEBell Textron Inc · Fort Worth, TXN17SPNew York State Police · Albany, NYN17TWWhirlybird Aviation LLC · Bend, ORN181MAMinuteman Aviation Inc · Missoula, MTN183PSkytech Cc LLC · Santa Rosa Beach, FLN184AMAir Methods LLC · Greenwood Village, CON184SFGm Leasing Co LLC · Broussard, LAN189AMAir Methods LLC · Greenwood Village, CON18BHAbc Helicopters Inc · Jefferson, WIN18SPState Of New York · Albany, NYN1903ADale County Sheriffs Office · Ozark, ALN190AETextron Financial Corp · Wichita, KSN192RLRotorcraft Leasing Co LLC · Broussard, LAN193AMAir Methods LLC · Greenwood Village, CON194TAJsj Aviation LLC · Helena, MTN1957ZDakota Rotors LLC · Custer, SDN196TAHelo N426ha LLC · Richmond, VAN19HXPremier Aircraft Services LLC · Bakersfield, CAN1MHIsaiah 40v31 LLC · Orlando, FLN201PAAsa Security LLC · Anchorage, AKN202MHSouthern Utah University · Cedar City, UTN202PHCoastal Air Services Inc · Panama City, FL
Back to AD 2003-13-10