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

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, CABuilt 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, FLS/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 N407GXBell Textron Inc · Fort Worth, TXBuilt 2012 · S/N 54300

Back to AD 2001-01-52 R1