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.

N229SFN179sf LLC · Chandler, AZBuilt 2005 · S/N 53652 N230DKGeorgia Department Of Public Safety · Kennesaw, GABuilt 2020 · S/N 54915 N233JSCreekside Aviation LLC · Nashville, NCBuilt 2008 · S/N 53886 N239MCCollier Mosquito Control District · Naples, FLBuilt 2019 · S/N 54830 N241MTMed-Trans Corp · Denton, TXBuilt 2011 · S/N 54056 N242MTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 54067 N246AMAir Methods LLC · Greenwood Village, COBuilt 2015 · S/N 54593 N24NRGeorgia Department Of Natural Resources · Atlanta, GABuilt 2012 · S/N 54312 N24NYHeliinc LLC · Wilmington, DEBuilt 2014 · S/N 54157 N253HBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 54172 N257JBBennett Aviation LLC · Slaughter, LABuilt 2023 · S/N 56361 N2592TBrown Helicopter Inc · Pensacola, FLBuilt 2007 · S/N 53748 N25AMBell Textron Inc · Fort Worth, TXBuilt 2026 · S/N 56482 N25NRGeorgia Department Of Natural Resources · Atlanta, GABuilt 2019 · S/N 54838 N262KBSkytoyz Enterprises LLC · Loveland, COBuilt 1999 · S/N 53380 N267SFN179sf LLC · Chandler, AZBuilt 1996 · S/N 53102 N26CHCoastal Air Service Inc · Panama City, FLBuilt 1998 · S/N 53312 N26NRGeorgia Department Of Natural Resources · Atlanta, GABuilt 2014 · S/N 54564 N26NXRegistered aircraftN-number assigned (import), not yet registeredS/N 54966 N26VAVirginia State Police · Richmond, VABuilt 2006 · S/N 53688 N272MJAir Methods LLC · Greenwood Village, COBuilt 2021 · S/N 54960 N278AMAir Methods LLC · Greenwood Village, COBuilt 2013 · S/N 54464 N27HXHelicopter Express LLC · Chamblee, GABuilt 1996 · S/N 53012 N280LBBell Textron Inc · Fort Worth, TXBuilt 2011 · S/N 54304 N284AMAir Methods LLC · Greenwood Village, COBuilt 2014 · S/N 54528 N284SPKentucky State Police · Frankfort, KYBuilt 2005 · S/N 53655 N2869FSilver Creek Aviation Services · Fort Worth, TXBuilt 2004 · S/N 53623 N286GJambb LLC · La Verne, CABuilt 1996 · S/N 53042 N289MSClipper Group LLC · Newport Beach, CABuilt 2025 · S/N 56456 N28LLHelicopters Inc · Wilmington, DEBuilt 2003 · S/N 53581 N292AMAir Methods LLC · Greenwood Village, COBuilt 2015 · S/N 54569 N293AMAir Methods LLC · Greenwood Village, COBuilt 2015 · S/N 54617 N294GRAir Evac Ems Inc · O Fallon, MOS/N 56495 N294VMGm Leasing Co LLC · Broussard, LABuilt 2007 · S/N 53781 N295GRRegistration Pending · O Fallon, MORegistration pendingS/N 56497 N296GRBell Textron Inc · Fort Worth, TXS/N 56508 N297CCClayton County Georgia · Jonesboro, GABuilt 2021 · S/N 54975 N301AMAir Methods LLC · Greenwood Village, COBuilt 2019 · S/N 54807 N301LELifeflight Eagle · Kansas City, MOBuilt 2013 · S/N 54406 N302LELifeflight Eagle · Kansas City, MOBuilt 2013 · S/N 54418 N3050SAr Aviation Group LLC · Springfield, ORBuilt 2006 · S/N 53742 N305CBBerichi Aviation Helicopters LLC · Fort Lauderdale, FLBuilt 2024 · S/N 56397 N306GRBell Textron Inc · Fort Worth, TXS/N 56505 N307KHGm Leasing Company LLC · Broussard, LABuilt 1997 · S/N 53172 N308MHMaritime Helicopters Inc · Homer, AKBuilt 2005 · S/N 53647 N308NEMed Trans Corp · Denton, TXBuilt 2022 · S/N 54992 N309LWStraight Up Leasing Inc · Medford, ORBuilt 2003 · S/N 53553 N309MHMaritime Helicopters Inc · Homer, AKBuilt 2006 · S/N 53728 N309RLRotorcraft Leasing Company LLC · Broussard, LABuilt 1996 · S/N 53092 N30BWAir Siete LLC · Wilmington, DEBuilt 2016 · S/N 54668

Back to AD 2001-01-52 R1