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.

N373RLRotorcraft Leasing Company LLC · Broussard, LABuilt 1999 · S/N 53373 N374ALAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 53819 N377RSGm Leasing Co LLC · Broussard, LABuilt 2003 · S/N 53584 N37ATCrosswind Leasing LLC · Prescott, AZBuilt 2004 · S/N 53593 N37HFHalo Flight Inc · Corpus Christi, TXBuilt 2021 · S/N 54932 N37MEMountain-Elkhorn Inc · Lexington, KYBuilt 1999 · S/N 53344 N383AMAir Methods LLC · Greenwood Village, COBuilt 2015 · S/N 54634 N383STState Of Michigan Department Of State Police · Lansing, MIBuilt 2016 · S/N 54680 N384MLParagon Air Group · Fort Worth, TXBuilt 2004 · S/N 53621 N38AJSale Reported · Madera, CASale reported, pending cancellationS/N 56317 N38BLHelicopters Inc · Wilmington, DEBuilt 1999 · S/N 53368 N390SFN390sf LLC · Chandler, AZBuilt 2000 · S/N 53407 N3914RRotorcraft Leasing Company LLC · Broussard, LABuilt 2009 · S/N 53914 N398AMAir Methods LLC · Greenwood Village, COBuilt 2014 · S/N 54492 N399SPSamaritans Purse · Boone, NCBuilt 2023 · S/N 56373 N39AEAir Evac Ems Inc · O Fallon, MOBuilt 1997 · S/N 53103 N39CLHelicopters Inc · Wilmington, DEBuilt 2004 · S/N 53612 N39KMFirst Flight Of Wyoming LLC · Billings, MTBuilt 2014 · S/N 54502 N3WVState Of West Virginia · Charleston, WVBuilt 2006 · S/N 53713 N400EEGore Nitrogen Pumping Service LLC · Seiling, OKBuilt 2013 · S/N 54457 N400PJHelibro LLC · Red Bluff, CABuilt 2006 · S/N 53705 N401HSt Johns County Sheriff Office · Saint Augustine, FLBuilt 2024 · S/N 56387 N401LFLife Flight Network LLC · Aurora, ORBuilt 2019 · S/N 54865 N401PHPhi Health LLC · Tempe, AZBuilt 2004 · S/N 53615 N401TDLeading Edge Aviation Inc · Bend, ORBuilt 2012 · S/N 54335 N402KTHelicopter Marketing Associates LLC · Colleyville, TXS/N 54639 N402LFLife Flight Network LLC · Aurora, ORBuilt 2019 · S/N 54867 N402MAMinuteman Aviation Inc · Missoula, MTBuilt 2008 · S/N 53834 N402PDCity Of Omaha · Omaha, NEBuilt 2012 · S/N 54322 N402PHPhi Health LLC · Tempe, AZBuilt 1997 · S/N 53159 N402PJHelibro LLC · Red Bluff, CABuilt 1997 · S/N 53195 N403APA & P Helicopters Inc · Richvale, CABuilt 2000 · S/N 53424 N403LFLife Flight Network LLC · Aurora, ORBuilt 2020 · S/N 54886 N403PHPhi Health LLC · Tempe, AZBuilt 1998 · S/N 53267 N403PJHelibro LLC · Red Bluff, CABuilt 1998 · S/N 53256 N403TDHfs Heli 1v LLC · New York, NYBuilt 2015 · S/N 54644 N404AMAir Methods LLC · Greenwood Village, COBuilt 2014 · S/N 54546 N404APA & P Helicopters Inc · Richvale, CABuilt 1997 · S/N 53228 N404LHLohman Helicopter LLC · Lewiston, IDBuilt 2007 · S/N 53777 N404LLRegistration Pending · Greenwood Village, CORegistration pendingBuilt 2000 · S/N 53446 N404NCNorth Carolina State Highway Patrol · Cary, NCBuilt 2007 · S/N 53788 N404PHPhi Health LLC · Tempe, AZBuilt 1997 · S/N 53188 N404TDHfs Heli II LLC · New York, NYBuilt 2014 · S/N 54487 N405LFLife Flight Network LLC · Aurora, ORBuilt 2020 · S/N 54905 N405LHLohman Helicopter LLC · Lewiston, IDBuilt 1998 · S/N 53240 N405NCNorth Carolina State Highway Patrol · Cary, NCBuilt 2008 · S/N 53814 N405SWSw Aviation LLC · Norman, OKBuilt 2013 · S/N 54391 N406APA&P Helicopters Inc · Richvale, CABuilt 1999 · S/N 53357 N406ASAero Leasing Inc · Medford, ORFirst renewal noticeBuilt 2002 · S/N 53520 N406LFLife Flight Network LLC · Aurora, ORBuilt 2021 · S/N 54977

Back to AD 98-19-13