AD 2002-04-07
Registered aircraft · 250
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:2002-04-07')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-04-07')
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:2002-04-07') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-04-07') 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.
N600HDU S Helicopters Inc · Marshville, NCN603CMSoutheast Helicopters LLC · Miami, FLN6080RTemsco Helicopters Inc · Ketchikan, AKN608TTemsco 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, DEN617TVUS Helicopters Inc · Marshville, NCN619LHYukon Helicopters Inc · Bethel, AKN61CVState Of Montana Dept Of Fish Wildlife & Parks · Helena, MTFirst renewal noticeN61HLTiny Bubbles Aviation Inc · Pacoima, CAN61RKDylans Rv Center LLC · Sewell, NJN624KSAerial Coalition Surveillance LLC · Winnie, TXN6302YTemsco Helicopter Inc · Ketchikan, AKN631SDCounty Of Oakland · Pontiac, MIN632SDCounty Of Oakland · Oakland, MIN63CBBmf Heli LLC · Ogden, UTN641EGCity Of Fontana California · Fontana, CAN646PTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN661PDRegistration Pending · MeafordRegistration pendingN662PDRegistration Pending · MeafordontarioRegistration pendingN665PDLapd Air Support Division · Los Angeles, CAN668MMColorado Highland Holdings LLC · Durango, CON668PDLos Angeles Police Dept Air Support Division · Los Angeles, CAN669TFRidgeline Aviation Inc · Cordova, AKN680DGState Of Montana Dept Of Fish Wildlife & Parks · Helena, MTN702SASaf Ltd · Lihue, HIN702TXJ5 Aerospace LLC · Harrisburg, NCN708SHDiscovery Helicopters LLC · Las Vegas, NVN711JHJack Harter Helicopters Inc · Lihue, HIN719AKMoro Aircraft Leasing Inc · Two Rivers, AKN71HDHelinet Aviation Services LLC · Van Nuys, CAN72LCLee County Sheriffs Office · Fort Myers, FLFirst renewal noticeN735SHSouthwest Geologic Survey LLC · Mesquite, NVN73HPOhio State Highway Patrol · Columbus, OHN744HDU S Helicopters Inc · Marshville, NCN745RHUnited Helicopter Leasing LLC · Honolulu, HIN745SHKenmore Crew Leasing Inc Trustee · Bellingham, WAN746RHUnited Helicopter Leasing LLC · Honolulu, HIN752CHCsc Delaware Trust Co Trustee · Wilmington, DEN775MAMercy Air Helicopter Inc · Fort Lauderdale, FLN779CPChaparral Air Group · Grapevine, TXN783FBFb Helicopter LLC · Banks, ORN79FXSouthern Helicopters Inc · Sunshine, LAN801HIsland Helicopters Kauai Inc · Lihue, HIN802THTemsco Helicopters Inc · Ketchikan, AKN808GTHaynes Aviation LLC · Wetumpka, ALN808SASaf Ltd · Lihue, HI
Back to AD 2002-04-07