Registered aircraft · 985

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

N407NYNew York City Police Aviation Unit · Brooklyn, NYBuilt 1996 · S/N 53061 N407PPhi Health LLC · Tempe, AZBuilt 2000 · S/N 53464 N407PAMaritime Helicopters Inc · Homer, AKBuilt 2003 · S/N 53567 N407PBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2021 · S/N 54942 N407PDCharlotte Mecklenburg Polic Deptartment · Charlotte, NCS/N 53161 N407PFBell Textron Inc · Fort Worth, TXBuilt 1997 · S/N 53157 N407PGRedding Air Service Inc · Redding, CABuilt 2007 · S/N 53771 N407PJP J Helicopters Inc · Red Bluff, CABuilt 2001 · S/N 53469 N407PMHc 407 LLC · Missoula, MTBuilt 2026 · S/N 56478 N407PRWindsock Managmement LLC · Little Rock, ARBuilt 1997 · S/N 53162 N407PWIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 2023 · S/N 56363 N407REastern Aviation Fuels Inc · New Bern, NCBuilt 2000 · S/N 53451 N407RATranspais Aviation LLC · Salt Lake City, UTBuilt 2013 · S/N 54396 N407RERegistered aircraftBuilt 2009 · S/N 53930 N407RFFlagstaff Medical Center · Flagstaff, AZBuilt 2009 · S/N 53919 N407RHMaritime Helicopters Inc · Homer, AKBuilt 1998 · S/N 53258 N407RJDixon John W · Asotin, WAFirst renewal noticeBuilt 2002 · S/N 53539 N407RLHillsboro Aviation Inc · Hillsboro, ORBuilt 2002 · S/N 53513 N407RMGarriott Robert · Austin, TXBuilt 2009 · S/N 53920 N407RRRains Ronald D · Odessa, TXBuilt 2012 · S/N 54332 N407RUIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 2022 · S/N 54988 N407RWSacremento Executive Helicopters Inc · Acampo, CABuilt 2012 · S/N 54355 N407RXBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 54402 N407SAAlabama Law Enforcement Agency · Montgomery, ALBuilt 2000 · S/N 53449 N407SDCounty Of Onondaga · Syracuse, NYBuilt 1999 · S/N 53330 N407SETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 54386 N407SFN390sf LLC · Chandler, AZBuilt 2006 · S/N 53737 N407SGSlg Utah LLC · Toquerville, UTFirst renewal noticeBuilt 2015 · S/N 54655 N407SHStanislaus County · Modesto, CABuilt 2014 · S/N 54501 N407SJSan Juan Aviation LLC · Wilmington, DEBuilt 2004 · S/N 53608 N407SKWest States Leasing Inc · Medford, ORBuilt 1997 · S/N 53174 N407SLIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 2021 · S/N 54985 N407SMMed-Trans Corp · Denton, TXBuilt 1998 · S/N 53289 N407SRRugged Flightworks LLC · Big Piney, WYBuilt 2001 · S/N 53495 N407SSState Of Indiana · Indianapolis, INBuilt 2011 · S/N 54303 N407TDElkhorn Aviation Inc · Baker City, ORBuilt 2007 · S/N 53764 N407TFTag Aviation LLC · Casper, WYBuilt 2005 · S/N 53644 N407THIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 2003 · S/N 53558 N407TJAdair Jay · Dallas, TXBuilt 2024 · S/N 56422 N407TKIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 2015 · S/N 54662 N407TVBlack Wolf Aviation LLC · Carencro, LAS/N 54812 N407TXAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 53892 N407USCrosswind Leasing LLC · Prescott, AZBuilt 1996 · S/N 53057 N407UTMed Trans Corp · Denton, TXBuilt 1996 · S/N 53036 N407VCBell Textron Inc · Fort Worth, TXBuilt 2018 · S/N 54806 N407VSKalispell Regional Medical Center · Kalispell, MTBuilt 2016 · S/N 54667 N407VVFlagstaff Medical Center Inc · Flagstaff, AZBuilt 2001 · S/N 53476 N407WAMed-Trans Corp · Denton, TXBuilt 1997 · S/N 53222 N407WDBrask T-4 Equipment LLC · Gallatin Gateway, MTBuilt 2019 · S/N 54851 N407WFBell 407 LLC · Bend, ORBuilt 2012 · S/N 54337

Back to AD 98-19-13