Registered aircraft · 1,115

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

N124TXTexas Department Of Public Safety · Austin, TXBuilt 2008 · S/N 4405 N125APAustin Police Dept · Pflugerville, TXBuilt 2022 · S/N 9282 N125CLHillsboro Aviation Inc · Hillsboro, ORBuilt 2015 · S/N 7987 N125DAPayne David L Trustee · Saint Louis, MOBuilt 2022 · S/N 9154 N125EPEnbridge Energy Co Inc · Houston, TXBuilt 2019 · S/N 8650 N125HDUS Helicopters Inc · Marshville, NCBuilt 2014 · S/N 7899 N125NBCisco Aero LLC · Grass Range, MTBuilt 2022 · S/N 9318 N125NYOffice Of Vector Surveillance And Control · New York, NYBuilt 2019 · S/N 8745 N125PDCity Of Albuquerque · Albuquerque, NMBuilt 2019 · S/N 8667 N125SCStandard Aero (Alliance) Inc · Maryville, TNBuilt 2005 · S/N 3904 N126BHBhi Holdings #2 LLC · Ontario, ORBuilt 2012 · S/N 7403 N126PJHelibro LLC · Red Bluff, CABuilt 2010 · S/N 7039 N127ABApexheli Oregon Inc · Florence, ORBuilt 2000 · S/N 3331 N127BHBhi Holdings #3 LLC · Ontario, ORBuilt 2013 · S/N 7675 N127PJHelibro LLC · Red Bluff, CABuilt 2011 · S/N 7180 N129NBPathfinder Leasing LLC · Anchorage, AKBuilt 2017 · S/N 8397 N129TVUS Helicopters Inc · Marshville, NCBuilt 1996 · S/N 2897 N12FQN12fq LLC · Helena, MTBuilt 2003 · S/N 3726 N12NNAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 2008 · S/N 4579 N12NYNew York Aircam Corp · Woodbury, NYBuilt 2018 · S/N 8594 N12YJTiny Bubbles Aviation Inc · Pacoima, CABuilt 2008 · S/N 4443 N130ADEurotec Vertical Flight Solutions LLC · Eudora, KSS/N 3515 N130AHHelio Helicopter Co LLC · Manchester, NHS/N 3862 N130BUOhio Medical Transportation Inc · Columbus, OHBuilt 2011 · S/N 7132 N130CLOhio Medical Transportation Inc · Columbus, OHBuilt 2012 · S/N 7499 N130CRRomana Aircraft Inc · High Point, NCBuilt 2007 · S/N 4271 N130CZOrbic Air LLC · Burbank, CABuilt 2006 · S/N 4060 N130EEBuckeye Leasing LLC · Shreveport, LABuilt 2011 · S/N 7190 N130GCMonarch Enterprises Inc · Kirkland, WABuilt 2002 · S/N 3562 N130GMBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 4837 N130HBOhio Medical Transportation Inc · Columbus, OHBuilt 2011 · S/N 7167 N130JVOhio Medical Transportation Inc · Columbus, OHBuilt 2012 · S/N 7490 N130KHOhio Medical Transportation Inc · Columbus, OHBuilt 2011 · S/N 7142 N130KJJackson Family Wines Inc · Santa Rosa, CABuilt 2004 · S/N 3873 N130KKInternational Air Services Inc Trustee · Carson City, NVS/N 4861 N130KRAir Methods LLC · Greenwood Village, COBuilt 2012 · S/N 7317 N130LHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 4017 N130LLEffort Aviation LLC · Wilmington, DEBuilt 2012 · S/N 7375 N130MDEc 130 II LLC · Sterling, VABuilt 2012 · S/N 7549 N130MUOhio Medical Transportation Inc · Columbus, OHBuilt 2011 · S/N 7103 N130NBBuckeye Leasing LLC · Shreveport, LABuilt 2011 · S/N 7221 N130NWOhio Medical Transportation Inc · Columbus, OHBuilt 2011 · S/N 7182 N130PFOrlando Helicopter Partners LLC · Orlando, FLBuilt 2009 · S/N 4760 N130SMInternational Air Services Inc Trustee · Carson City, NVBuilt 2007 · S/N 4276 N130WSWorld Trade Enterprises LLC · Lucas, TXBuilt 2003 · S/N 3735 N131GCRainier Heli International Inc · Kirkland, WABuilt 2003 · S/N 3691 N131LNAir Methods LLC · Greenwood Village, COS/N 4090 N131WSWorld Trade Enterprises LLC · Lucas, TXS/N 3521 N132BHBrainerd Helicopters Inc · Leesburg, FLBuilt 2007 · S/N 4374 N132GCAmerican Helicopters LLC · Kirkland, WABuilt 2003 · S/N 3756

Back to AD 2002-03-52