AD 2003-08-06
Registered aircraft · 273
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-08-06')
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-08-06')
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-08-06') 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-08-06') 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.
N540DBMaster Link Corp · Barceloneta, PRN543MMHappyheight 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, NVN57954Ns Air Leasing LLC · Wilmington, DEN5805TStefenelli Aviation N-Tr Inc Trustee · AtterseeN5854ZPuerto Rico Electric Power Authority · Carolina, PRN5855ZPuerto Rico Electric Power Authority · San Juan, PRN596MSNs Air Leasing LLC · Wilmington, DEN596WAFleet Unlimited Inc · Pasadena, CAN600HDU 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, DEN613CMEurotec Vertical Flight Solutions LLC · Eudora, KSN614SDEurotec Vertical Flight Solutions LLC · Eudora, KSN617TVUS 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, CA
Back to AD 2003-08-06