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.

N407WHScouts Rest Ranch LLC · Darby, MTBuilt 2001 · S/N 53503 N407WTSeaguard Aviation LLC · Kalispell, MTBuilt 2024 · S/N 56420 N407XLExecutive Transport Group Inc · Las Vegas, NVS/N 53658 N407YCTvpx Ars Inc Trustee · North Salt Lake, UTS/N 54994 N407ZMIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 2009 · S/N 53972 N408APA & P Helicopters Inc · Richvale, CABuilt 1997 · S/N 53197 N408CCCounty Of Contra Costa · Martinez, CABuilt 2014 · S/N 54542 N408GAFlagstaff Medical Center Inc · Flagstaff, AZBuilt 1999 · S/N 53392 N408GGHfs Heli III LLC · New York, NYBuilt 2014 · S/N 54558 N408GMBostick Bowers Padgett Ltd · Jackson, GABuilt 2011 · S/N 54307 N408LFLife Flight Network LLC · Aurora, ORBuilt 2021 · S/N 54978 N408LLAir Methods LLC · Greenwood Village, COBuilt 2001 · S/N 53483 N408LMAir Methods LLC · Greenwood Village, COBuilt 2015 · S/N 54620 N408LNAir Methods LLC · Greenwood Village, COBuilt 2013 · S/N 54433 N408PJHelibro LLC · Red Bluff, CABuilt 1998 · S/N 53286 N408SHAir Methods LLC · Greenwood Village, COBuilt 2013 · S/N 54467 N408SK911 Aviation LLC · Durant, OKBuilt 2012 · S/N 54362 N408TVTennessee Valley Authority · Muscel Shoals, ALBuilt 2020 · S/N 54912 N408UHUniversity Of Utah · Salt Lake City, UTFirst renewal noticeBuilt 2005 · S/N 53663 N408UTMed-Trans Corp · Denton, TXBuilt 2007 · S/N 53808 N409APA&P Helicopters Inc · Richvale, CABuilt 1997 · S/N 53126 N409GAFlagstaff Medical Center Inc · Flagstaff, AZBuilt 2007 · S/N 53790 N409LFLife Flight Network LLC · Aurora, ORS/N 56331 N409LMAir Methods LLC · Greenwood Village, COBuilt 2015 · S/N 54621 N409PHPhi Health LLC · Tempe, AZBuilt 2004 · S/N 53626 N409PJHelibro LLC · Red Bluff, CABuilt 1998 · S/N 53301 N409TDCastle Black Aviation LLC · Manati, PRBuilt 2008 · S/N 53830 N40DNBank Of Utah Owner Trustee 11/20/2023 · Salt Lake City, UTBuilt 2023 · S/N 56374 N40KDZero Kilodelta LLC · Littleton, NCBuilt 2013 · S/N 54453 N40VRSanctuary Partners LLC · Ball Ground, GABuilt 2014 · S/N 54482 N410APA&P Helicopters Inc · Richvale, CABuilt 1997 · S/N 53091 N410LFLife Flight Network LLC · Aurora, ORBuilt 2023 · S/N 56332 N410PHPhi Health LLC · Tempe, AZBuilt 2005 · S/N 53636 N410TD407 Partners LLC · Bend, ORBuilt 2012 · S/N 54336 N411LFLife Flight Network LLC · Aurora, ORS/N 56333 N411PPhi Health LLC · Tempe, AZBuilt 1998 · S/N 53288 N411PHPhi Health LLC · Tempe, AZBuilt 2005 · S/N 53637 N411PJHelibro LLC · Red Bluff, CABuilt 1996 · S/N 53045 N411PRWindsock Management LLC · Little Rock, ARBuilt 2009 · S/N 53961 N411TPCity Of Tampa Police Department · Tampa, FLBuilt 2001 · S/N 53487 N411UHUniversity Of Utah · Salt Lake City, UTBuilt 2012 · S/N 54330 N412CFCareflite · Grand Prairie, TXBuilt 2016 · S/N 54665 N412LFLife Flight Network LLC · Aurora, ORBuilt 2023 · S/N 56342 N412PPhi Health LLC · Tempe, AZBuilt 2013 · S/N 54135 N412PHPhi Aviation LLC · Lafayette, LABuilt 2008 · S/N 53862 N412UHMetro Aviation Inc · Shreveport, LABuilt 2011 · S/N 54305 N413CFCareflite - Grand Prairie · Grand Prairie, TXS/N 56306 N413UHMetro Aviation Inc · Shreveport, LABuilt 2012 · S/N 54341 N4144CTen Point Tours Inc · Nashville, TNS/N 53921 N414LFLife Flight Network LLC · Aurora, ORBuilt 2023 · S/N 56343

Back to AD 98-19-13