Registered aircraft · 298

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:86-15-10-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:86-15-10-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:86-15-10-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:86-15-10-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:86-15-10-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:86-15-10-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.

N351FSDiscovery Helicopters LLC · Las Vegas, NVBuilt 1997 · S/N 3038 N351FWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2009 · S/N 4704 N351HNDiscovery Helicopters LLC · Las Vegas, NVBuilt 1996 · S/N 2957 N351VSAlpine Air Alaska LLC · Girdwood, AKBuilt 2000 · S/N 3298 N352PDSuffolk County Police Department · Yaphank, NYBuilt 2009 · S/N 4741 N352VHElt Holdings LLC · Cottonwood, AZBuilt 1985 · S/N 1838 N353FSDiscovery Helicopters LLC · Boulder City, NVBuilt 1998 · S/N 3127 N353JSCedar Heights Aircraft LLC · Rhinebeck, NYBuilt 2005 · S/N 3931 N354AKAris Aviation Group LLC · Boulder City, NVS/N 4145 N354HDCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1991 · S/N 2479 N354PDSuffolk County Police Department · Yaphank, NYBuilt 2004 · S/N 3889 N355AGHover-Views Unlimited Inc · Syosset, NYBuilt 1982 · S/N 5109 N355ERElite Rotorcraft LLC · Mt Juliet, TNBuilt 1990 · S/N 5436 N355EXSolomon Mark Trustee · Wilmington, DEBuilt 1994 · S/N 2817 N355FFRichards William · Gardiner, NYBuilt 1982 · S/N 5133 N355HCAm Air Service LLC · Green Oaks, ILS/N 5184 N355HRNext Level Aviation LLC · Pflugerville, TXBuilt 1991 · S/N 5473 N355JCMavana As LLC · Miami, FLS/N 5517 N355RSThompson Flying Service LLC · Charleston, MOBuilt 2008 · S/N 4586 N355SFHowe Aviation LLC · Surprise, AZS/N 5054 N355THTimberland Helicopters Inc · Ashland, ORBuilt 1981 · S/N 5111 N358TVTiny Bubbles Aviation Inc · Pacoima, CABuilt 2004 · S/N 3788 N3598DPope James Dean · Lewiston, IDBuilt 1979 · S/N 1152 N35YYMike Rinker Aircraft LLC · Union City, TNBuilt 2009 · S/N 4673 N3604TRotorcraft Support Inc · Fillmore, CABuilt 1979 · S/N 1158 N360CHCoastal Helicopters Inc · Juneau, AKBuilt 1991 · S/N 2526 N367AMAir Services International Leasing LLC · Fort Lauderdale, FLS/N 2926 N36TVUS Helicopters Inc · Marshville, NCS/N 1858 N375MBMh22 LLC · Minotola, NJBuilt 2007 · S/N 4337 N381AKAlpha Aviation LLC · Anchorage, AKBuilt 1992 · S/N 2641 N382AKAlpha Aviation LLC · Anchorage, AKBuilt 2002 · S/N 3591 N384AKAlpha Aviation LLC · Anchorage, AKBuilt 1998 · S/N 3092 N390NSNorthstar Trekking LLC · Juneau, AKBuilt 1992 · S/N 2615 N391NSNorthstar Trekking LLC · Juneau, AKS/N 3481 N392NSNorthstar Trekking LLC · Juneau, AKBuilt 2006 · S/N 4166 N393NSNorth Star Trekking LLC · Juneau, AKBuilt 2009 · S/N 4762 N394NSNorthstar Trekking · Juneau, AKBuilt 1979 · S/N 1066 N4022DTemsco Helicopters Inc · Ketchikan, AKBuilt 1995 · S/N 2891 N4035WDepartment Of Homeland Security · Washington, DCBuilt 1996 · S/N 2912 N4048LU S Dept Of Homeland Security · Washington, DCBuilt 1997 · S/N 3020 N4055LU S Dept Of Homeland Security · Washington, DCBuilt 1996 · S/N 2916 N40584Bristow LLC · Lake Charles, LABuilt 1998 · S/N 2924 N405AMAris Aviation Group LLC · Henderson, NVBuilt 1995 · S/N 2833 N405TXTexas Department Of Public Safety · Austin, TXBuilt 2008 · S/N 4476 N4061GBristow LLC · Lake Charles, LABuilt 1997 · S/N 3051 N4068WU S Dept Of Homeland Security · Washington, DCBuilt 1996 · S/N 2934 N406AMAris Aviation Group LLC · Boulder City, NVBuilt 1990 · S/N 2391 N4074EAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1996 · S/N 2950 N4075SD&B Global Ventures LLC · Key West, FLBuilt 1997 · S/N 3043 N410CKCharm City Aviation LLC · Baltimore, MDBuilt 2004 · S/N 3793

Back to AD 86-15-10 R2