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.

N406NCNorth Carolina State Highway Patrol · Cary, NCBuilt 2023 · S/N 56335 N406PDCharlotte-Mecklenburg Police Dept · Charlotte, NCBuilt 2024 · S/N 56393 N406PHPhi Health LLC · Tempe, AZBuilt 1997 · S/N 53198 N406PJHelibro LLC · Red Bluff, CABuilt 2000 · S/N 53466 N406TDHfs Heli V LLC · New York, NYBuilt 2006 · S/N 53745 N406TRBrask T-4 Equipment LLC · Gallatin Gateway, MTBuilt 2025 · S/N 56473 N406TVTennessee Valley Authority · Muscle Shoals, ALBuilt 2020 · S/N 54900 N407ABank Of Utah Trustee · Salt Lake City, UTBuilt 2024 · S/N 56389 N407AGBank Of Utah Trustee · Salt Lake City, UTBuilt 2020 · S/N 54893 N407AMAir Methods LLC · Greenwood Village, COBuilt 1998 · S/N 53309 N407APA & P Helicopters Inc · Richvale, CABuilt 1999 · S/N 53370 N407ARMed-Trans Corp · Denton, TXBuilt 2012 · S/N 54092 N407ATBizpay Aviation LLC · Tulsa, OKBuilt 2024 · S/N 56410 N407BBBravo Bravo LLC · Chandler, AZBuilt 2004 · S/N 53603 N407BDLitton Global LLC · Wilmington, DEBuilt 2020 · S/N 54891 N407BEL J Associates Inc · Latrobe, PABuilt 2003 · S/N 53576 N407BGAscendancy Aviation LLC · Melbourne Beach, FLBuilt 2007 · S/N 53796 N407BJ911 Aviation LLC · Durant, OKBuilt 2008 · S/N 53897 N407BKTactical Ops Support LLC · Ridge, NYS/N 54850 N407BMBravo Operations LLC · Newark, DEBuilt 2017 · S/N 54714 N407BPBell Textron Inc · Fort Worth, TXBuilt 1999 · S/N 53355 N407BRBlaise Alexander Management Inc · Muncy, PABuilt 2019 · S/N 54846 N407BUTms Aircraft Leasing LLC · Shreveport, LABuilt 2013 · S/N 54444 N407BYIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 2021 · S/N 54980 N407CCCounty Of Contra Costa · Martinez, CAFirst renewal noticeBuilt 1997 · S/N 53090 N407CHClassic Medical Inc · North Salt Lake, UTBuilt 1996 · S/N 53011 N407CMSacramento Executive Helicopters Inc · Acampo, CABuilt 2006 · S/N 53722 N407CNIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 1998 · S/N 53314 N407CPClassic Medical Inc · North Salt Lake, UTBuilt 1997 · S/N 53095 N407CRMed-Trans Corp · Denton, TXBuilt 1998 · S/N 53254 N407CZIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 2021 · S/N 54981 N407DADillon Aero Inc · Scottsdale, AZBuilt 2019 · S/N 54863 N407DBBrock Bell LLC · Beaumont, TXBuilt 2000 · S/N 53419 N407DEPamoin 407 LLC · Brooklyn, NYBuilt 2013 · S/N 54389 N407DKPatagual Leasing LLC Trustee · Healdsburg, CABuilt 2015 · S/N 54583 N407DTN407dt LLC · Missoula, MTBuilt 2004 · S/N 53625 N407DVMike Hotel Corp · Wilmington, DEBuilt 1996 · S/N 53080 N407EMountain Pacific Aviation LLC · Bellevue, WABuilt 1996 · S/N 53019 N407ESDarana Aviation Services LLC · Hamilton, OHBuilt 2019 · S/N 54877 N407FCIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 1996 · S/N 53050 N407FGState Of Nevada · Reno, NVBuilt 2008 · S/N 53853 N407FHVertol Systems Company Inc · Destin, FLFirst renewal noticeS/N 53026 N407FLSarasota County Sheriffs Office · Sarasota, FLBuilt 2012 · S/N 54357 N407FMIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 2021 · S/N 54930 N407GFGeorgia Forestry Commission · Macon, GABuilt 2000 · S/N 53452 N407GHRotorcraft Support Inc · Fillmore, CABuilt 1996 · S/N 53075 N407GMBell Textron Inc · Fort Worth, TXBuilt 2020 · S/N 54805 N407GPSacramento Executive Helicopters Inc · Acampo, CABuilt 2011 · S/N 54088 N407GRGrand River Dam Authority · Tulsa, OKBuilt 2022 · S/N 54979 N407GSWindsock Management LLC · Little Rock, ARBuilt 2010 · S/N 53991

Back to AD 98-19-13