Skip to content

Registered aircraft · 297

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.

N101MZBohonis David C · North DeltaNon-citizen corporation, flight hours not reportedBuilt 1980 · S/N 5045 N102UMTimberland Helicopters Inc · Ashland, ORBuilt 1981 · S/N 5075 N108TABristow LLC · Lake Charles, LABuilt 1998 · S/N 3080 N109TALima Whiskey Alpha LLC · Missoula, MTBuilt 1998 · S/N 3103 N10MYBoston Executive Helicopters LLC · Norwood, MABuilt 1991 · S/N 5500 N111LNC Lou Leasing LLC · Mankato, MNBuilt 1984 · S/N 1602 N113JPJuliette Papa Leasing LLC · Kalispell, MTBuilt 1989 · S/N 2265 N113PHCherokee Helicopter Service LLC · Ford City, PABuilt 1980 · S/N 1298 N114MXAir Resources Helicopters Inc · Salt Lake City, UTBuilt 1984 · S/N 1747 N117HDUS Helicopters Inc · Marshville, NCS/N 3318 N117TVU S Helicopters Inc · Marshville, NCBuilt 2012 · S/N 7464 N119TVU S Helicopters Inc · Marshville, NCBuilt 1988 · S/N 2122 N1231ATiny Bubbles Aviation Inc · Pacoima, CABuilt 2003 · S/N 3682 N124LNAir Methods LLC · Greenwood Village, COBuilt 2006 · S/N 4130 N124TXTexas Department Of Public Safety · Austin, TXBuilt 2008 · S/N 4405 N125HDUS Helicopters Inc · Marshville, NCBuilt 2014 · S/N 7899 N125SCStandard Aero (Alliance) Inc · Maryville, TNBuilt 2005 · S/N 3904 N129TVUS Helicopters Inc · Marshville, NCBuilt 1996 · S/N 2897 N12FQN12fq LLC · Helena, MTBuilt 2003 · S/N 3726 N12NNAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 2008 · S/N 4579 N12YJTiny Bubbles Aviation Inc · Pacoima, CABuilt 2008 · S/N 4443 N132TVU S Helicopters Inc · Marshville, NCBuilt 1982 · S/N 1636 N134TVNexstar Broadcasting Inc · Albuquerque, NMBuilt 2007 · S/N 4291 N135MCWings Up IV LLC · Allen Park, MIBuilt 2004 · S/N 3826 N141THTemsco Helicopters Inc · Ketchikan, AKBuilt 1979 · S/N 1167 N143GKN143gk LLC · Sheridan, WYBuilt 2002 · S/N 3606 N145KKato Aviation LLC · Henderson, MNBuilt 1979 · S/N 1157 N145THTemsco Helicopters Inc · Ketchikan, AKBuilt 2003 · S/N 9060 N147THTemsco Helicopters Inc · Ketchikan, AKBuilt 2005 · S/N 9070 N148THTemsco Helicopters Inc · Ketchikan, AKBuilt 2008 · S/N 4623 N149THTemsco Helicopters Inc · Ketchikan, AKBuilt 2005 · S/N 9071 N151ADAtlantic Coast Maintenance · Palm Coast, FLS/N 1173 N152RMBank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N 3422 N179MTAnalar Corp · Princeton, NJS/N 5183 N1811FMaster Link Corp · Barceloneta, PRS/N 3430 N183EHBristow LLC · Lake Charles, LABuilt 1993 · S/N 2752 N184SDCounty Of Orange - Air Support · Costa Mesa, CAS/N 4009 N193BHBlack Mountain Aviation LLC · Boulder City, NVBuilt 1995 · S/N 2894 N197BHNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 1992 · S/N 2666 N1SDPinellas County Sheriffs Office · Clearwater, FLBuilt 2015 · S/N 8024 N202SCNs Air Leasing LLC · Wilmington, DEBuilt 1982 · S/N 5204 N203CHCoastal Helicopters Inc · Juneau, AKBuilt 1981 · S/N 1430 N204CHCoastal Helicopters · Juneau, AKBuilt 1981 · S/N 2054 N2127SEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 1989 · S/N 2213 N212CMAerospace Trust Management LLC Trustee · Wilmington, DES/N 2232 N214EHBristow LLC · Lake Charles, LABuilt 1998 · S/N 3163 N214GHCobalt Holdings Inc · Pacoima, CABuilt 1991 · S/N 2537 N214STBank Of Utah Trustee · Salt Lake City, UTS/N 2141 N215EHBristow LLC · Lake Charles, LABuilt 1998 · S/N 3172 N216CHCoastal Helicopters Inc · Juneau, AKBuilt 2002 · S/N 3619

Back to AD 86-15-10 R2