AD 2003-11-08
Registered aircraft · 203
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-11-08')
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-11-08')
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-11-08') 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-11-08') 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.
N420JABristow LLC · Lake Charles, LAN448AEShedhorn Construction Inc · Bozeman, MTN44DSDs Air II LLC · Carrollton, VAN450CCHosking Aviation Inc · Bountiful, UTN461SAAir Twinlite Inc Trustee · Wilmington, DEN498AEPhi Health LLC · Tempe, AZN503PHCity Of Miami Police Department · Miami, FLN511SCSabercat Productions LLC · Scottsdale, AZN522SCSouth Coast Helicopters LLC · Fullerton, CAN543MMHappyheight Inc · El Monte, CAN547AMTrevor Corp DBA · Grayslake, ILN547SAShier Aviation Corp DBA · San Diego, CAN557CBChaparral Air Group · Grapevine, TXN568AMEurotec Vertical Flight Solutions LLC · Eudora, KSN573AMIsland Air LLC · Westbury, NYN576AMAris Aviation Group LLC · Henderson, NVN5805TStefenelli Aviation N-Tr Inc Trustee · AtterseeN5854ZPuerto Rico Electric Power Authority · Carolina, PRN5855ZPuerto Rico Electric Power Authority · San Juan, PRN585AEPhi Health LLC · Tempe, AZN590AEPhi Health LLC · Tempe, AZN596WAFleet Unlimited Inc · Pasadena, CAN6080RTemsco Helicopters Inc · Ketchikan, AKN6094ETemsco Helicopters Inc · Ketchikan, AKN6094UTemsco Helicopters Inc · Ketchikan, AKN609TXCopters In Agriculture Llp · Sonora, TXN60TXTexas Department Of Public Safety · Austin, TXN611TCAircraft Trustee Services Inc Trustee · Dover, DEN61CVState Of Montana Dept Of Fish Wildlife & Parks · Helena, MTFirst renewal noticeN624KSAerial Coalition Surveillance LLC · Winnie, TXN632SDCounty Of Oakland · Oakland, MIN646PTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN661PDRegistration Pending · MeafordRegistration pendingN662PDRegistration Pending · MeafordontarioRegistration pendingN665PDLapd Air Support Division · Los Angeles, CAN668PDLos Angeles Police Dept Air Support Division · Los Angeles, CAN680DGState Of Montana Dept Of Fish Wildlife & Parks · Helena, MTN6UXHelicopters Inc · Cahokia, ILN702SASaf Ltd · Lihue, HIN702TXJ5 Aerospace LLC · Harrisburg, NCN708SHDiscovery Helicopters LLC · Las Vegas, NVN719AKMoro Aircraft Leasing Inc · Two Rivers, AKN71HDHelinet Aviation Services LLC · Van Nuys, CAN72LCLee County Sheriffs Office · Fort Myers, FLFirst renewal noticeN735SHSouthwest Geologic Survey LLC · Mesquite, NVN744HDU S Helicopters Inc · Marshville, NCN745RHUnited Helicopter Leasing LLC · Honolulu, HIN745SHKenmore Crew Leasing Inc Trustee · Bellingham, WAN746RHUnited Helicopter Leasing LLC · Honolulu, HIN775MAMercy Air Helicopter Inc · Fort Lauderdale, FL
Back to AD 2003-11-08