Skip to content

AD 2015-06-02 R2

Registered aircraft · 58

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

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:2015-06-02-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2015-06-02-R2') ORDER BY n_number

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:2015-06-02-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2015-06-02-R2')
  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:2015-06-02-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2015-06-02-R2')
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.

N137HPCalifornia Highway Patrol · Sacramento, CABuilt 2015 · S/N GA8-TC 320-15-218 N139HPCalifornia Highway Patrol · Sacramento, CABuilt 2015 · S/N GA8-TC-320-15-224 N13AVGrant Aviation Inc · Anchorage, AKBuilt 2003 · S/N GA8-03-028 N140HPCalifornia Highway Patrol · Sacramento, CABuilt 2013 · S/N GA8-TC-320-13-198 N148HPAlternative Travel LLC · Loveland, COBuilt 2016 · S/N GA8-TC-320-16-229 N152VPConservation Aviation LLC · Washington, DCBuilt 2011 · S/N GA8-11-160 N153HPCalifornia Highway Patrol · Sacramento, CABuilt 2016 · S/N GA8-TC-320-16-232 N156HPCalifornia Highway Patrol · Sacramento, CABuilt 2016 · S/N GA8-TC-320-16-234 N159HPCalifornia Highway Patrol · Sacramento, CABuilt 2018 · S/N GA8-TC-320-18-246 N165PWCounty Of San Bernardino · San Bernardino, CABuilt 2014 · S/N GA8-TC 320-14-205 N1753SFsa Aviation Inc · Wilmington, DEBuilt 2012 · S/N GA8-TC 320-12-175 N209PDModesto Police Department · Modesto, CABuilt 2012 · S/N GA8-TC 320-12-186 N215AVNational Test Pilot School · Mojave, CABuilt 2002 · S/N GA8-02-015 N225AVY-O Cattle Co LLC · Laredo, TXS/N GA8-TC 320-13-192 N234EAApache Airvan LLC · Greenville, DES/N GA8-02-021 N244CJPaula Stewart LLC · Saipan, MPBuilt 2017 · S/N GA8-TC-320-17-239 N255AVPaula Stewart LLC · Saipan, MPBuilt 2015 · S/N GA8-TC-320-15-215 N265PWSan Bernardino County Sheriff'S Department · San Bernardino, CABuilt 2018 · S/N GA8-TC 320-18-250 N267MALease Air LLC · Moab, UTS/N GA8-TC 320-11-167 N26NANatron Air Inc · Soldotna, AKBuilt 2002 · S/N GA8-02-018 N291BWWings Over Kauai LLC · Kalaheo, HIBuilt 2017 · S/N GA8-17-240 N470CPCivil Air Patrol · Maxwell Afb, ALS/N GA8-04-068 N471CPCivil Air Patrol · Maxwell Afb, ALS/N GA8-04-070 N472CPInternational Air Services Inc Trustee · Carson City, NVS/N GA8-05-072 N474CPCamber Aviation LLC · Mesa, AZS/N GA8-05-077 N495KBWipaire Inc · South Saint Paul, MNBuilt 2011 · S/N GA8-TC 320-11-168 N525AVGlobal Air Concepts LLC · Anchorage, AKBuilt 2016 · S/N GA8-16-227 N578GVGrant Aviation Inc · Anchorage, AKBuilt 2004 · S/N GA8-04-066 N588AVAir Ventures Hawaii LLC · Lihue, HIBuilt 2005 · S/N GA8-05-076 N601BZN501bz LLC · Boca Raton, FLS/N GA-8-04-064 N605CPInternational Air Services Inc Trustee · Carson City, NVS/N GA8-03-030 N606CPGrant Aviation Inc · Anchorage, AKBuilt 2003 · S/N GA8-03-036 N607CPCivil Air Patrol · Maxwell Afb, ALS/N GA8-04-049 N608CPWings Over Kauai LLC · Kalaheo, HIS/N GA8-04-052 N609CPCivil Air Patrol · Maxwell Afb, ALS/N GA8-04-054 N610CPCivil Air Patrol · Maxwell Afb, ALS/N GA8-04-056 N611CPCivil Air Patrol · Maxwell Afb, ALS/N GA8-04-058 N612CPCivil Air Patrol · Maxwell Afb, ALS/N GA8-04-060 N613CPGrant Aviation Inc · Anchorage, AKS/N GA8-04-062 N616AVSouthern Aviation Ga LLC · Anchorage, AKBuilt 2016 · S/N GA8-16-228 N617AVSouthern Aviation Ga LLC · Anchorage, AKBuilt 2016 · S/N GA8-16-230 N65HPOhio Department Of Public Safety · Columbus, OHBuilt 2018 · S/N GA8-TC-320-18-247 N68GASky Combat Blue LLC · Brookhaven, GABuilt 2012 · S/N GA8-TC 320-12-187 N699AVAir Ventures Hawaii LLC · Lihue, HIBuilt 2006 · S/N GA8-06-106 N7050FCity Of Houston · Houston, TXBuilt 2020 · S/N GA8-20-262 N721AVAir Ventures Hawaii LLC · Lihue, HIBuilt 2007 · S/N GA8-07-121 N7508MWings Over Kauai LLC · Kalaheo, HIS/N GA8-05-094 N752SEAtkins Alvin R Trustee · Barnstead, NHBuilt 2012 · S/N GA8-TC 320-12-183 N753SEInternational Air Services Inc Trustee · Carson City, NVBuilt 2014 · S/N GA8-15-209 N754SEInternational Air Services Inc Trustee · Carson City, NVBuilt 2012 · S/N GA8-TC 320-12-174

Back to AD 2015-06-02 R2