AD 2000-16-52
Registered aircraft · 647
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:2000-16-52')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-16-52')
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:2000-16-52') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-16-52') 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.
N556SDHarris County Sheriffs Office · Houston, TXN556TXTexas Dept Of Public Safety · Austin, TXN559SHCsc Delaware Trust Co Trustee · Wilmington, DEN562AHRegistered aircraftN568AENs Air Leasing LLC · Wilmington, DEN570AETemsco Helicopters Inc · Ketchikan, AKN574AMAir Methods LLC · Greenwood Village, CON582RDCity Of San Antonio · San Antonio, TXN583SHCsc Delaware Trust Co Trustee · Wilmington, DEN585AEPhi Health LLC · Tempe, AZN589SHCsc Delaware Trust Co Trustee · Wilmington, DEN590AEPhi Health LLC · Tempe, AZN594LGAir Methods LLC · Greenwood Village, CON594MCEast Flagler Mosquito Control District · Palm Coast, FLN596LGAir Methods LLC · Greenwood Village, CON597LGAir Methods LLC · Greenwood Village, CON599SDPima County Sheriffs Department · Tucson, AZN5JVAirbus Helicopters Inc · Grand Prairie, TXN600RSHella Fun 1 LLC · Belle Isle, FLN601TATrans Aero LLC · Cheyenne, WYN604SPAirbus Helicopters Inc · Grand Prairie, TXN60NTCity Of Ontario · Ontario, CAN610JSListo Air LLC · San Antonio, TXN610SFReach Air Medical Services LLC · Mcclellan, CAN612RXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN613RXReach Air Medical Services LLC · Santa Rosa, CAN613TCT A F Y Consulting · Bristow, VAN614HHSky High Leasing LLC · Montrose, CON614RXReach Air Medical Services LLC · Santa Rosa, CAN614TCTafy Consulting · Bristow, VAN615GRReach Air Medical Services LLC · Lewisville, TXN617CDOklahoma II LLC · Sandy, UTN617GCGranite Coast Mapping · Coronado, CAN618MEMountain Air Helicopters Inc · Dover, DEN61RXReach Air Medical Services LLC · Mcclellan, CAN61WLCorpat Inc · Missoula, MTN6211Department Of Homeland Security · Washington, DCN621FBCity Of Phoenix · Phoenix, AZN6227Austin Police Dept · Pflugerville, TXN622FBCity Of Phoenix · Phoenix, AZN623FBCity Of Phoenix · Phoenix, AZN623PDCoastal Helicopters LLC · La Vern, CAN624FBCity Of Phoenix · Phoenix, AZN625FBCity Of Phoenix · Phoenix, AZN629AMAir Methods LLC · Greenwood Village, CON62ARBird Dog Aircraft LLC · Billings, MTN62RXReach Air Medical Services LLC · Santa Rosa, CAN631SBSan Bernardino County Sheriffs Dept · San Bernardino, CAN63MCMissouri Department Of Conservation · Jefferson City, MON63RCKootenai Business Properties LLC · Post Falls, ID
Back to AD 2000-16-52