Registered aircraft · 7,866

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:2003-24-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:2003-24-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:2003-24-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:2003-24-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:2003-24-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:2003-24-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.

N125ALNby Productions · Bristow, VABuilt 2021 · S/N T20609639 N125JABillmans Inc · Cut Bank, MTBuilt 2005 · S/N 18281527 N125LFHubbard Capital LLC · Nashville, TNBuilt 2023 · S/N T20609729 N125LGWheat Travis W · Henderson, NVS/N 18280070 N125MDMaryland Aviation Administration · Bwi Airport, MDBuilt 2000 · S/N 20608099 N125SLSlingshot Aviation LLC · Chandler, AZBuilt 2003 · S/N 18281253 N125TWSmith Susan · Scottsdale, AZBuilt 2023 · S/N 172S13023 N125WEOhio State University · Columbus, OHBuilt 2019 · S/N 172S12303 N125WWRegistered aircraftBuilt 1998 · S/N 18280348 N1260KChristiansen Aviation LLC · Wilmington, DEBuilt 2023 · S/N 172S13053 N1261Evy Holdings Inc · White Marsh, MDBuilt 2006 · S/N 172S10322 N12675Van Bortel Aircraft Inc · Arlington, TXBuilt 2007 · S/N 18282026 N126AAAmerican Aviation Inc · Brooksville, FLBuilt 2005 · S/N 172S10076 N126AVN106ka LLC · Manassas, VAS/N 172S10621 N126BSCape Island Aviation LLC · Millville, NJBuilt 2017 · S/N 172S12012 N126HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2002 · S/N 172S9053 N126KMHessel Aviation LLC · Wilmington, DEBuilt 2007 · S/N T18208701 N126MEGlobal Flight Training Solutions Inc · Immokalee, FLFirst renewal noticeS/N 172S8378 N126SPPilling Stephen · Southport, NCBuilt 2005 · S/N 172S9796 N1270KChristiansen Aviation LLC · Wilmington, DEBuilt 2023 · S/N 172S13057 N12730Silver Creek Aviation Services · Fort Worth, TXBuilt 2007 · S/N 20608302 N1274VDiamond Specialized Inc · Richmond, OHBuilt 2008 · S/N T18208807 N1276AAir Land Ventures 3 LLC · Berwyn, PABuilt 2007 · S/N T20608794 N1277WRush Aviation Rentals Inc · Meridian, IDBuilt 2001 · S/N 172S8846 N127CFGeorgia Forestry Commission · Macon, GABuilt 2007 · S/N 18282027 N127HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2003 · S/N 172S9532 N127JEGillian Michael · Batavia, ILBuilt 2006 · S/N T20608678 N127KWElizabeth City State University · Elizabeth City, NCBuilt 2005 · S/N 172S9827 N127SLGulf Coast Helicopters Inc · Pearland, TXBuilt 2003 · S/N 18281256 N1280KChristiansen Aviation LLC · Wilmington, DEBuilt 2023 · S/N 172S13064 N1281QMaranatha Insurance Services Inc · Rancho Cucamonga, CABuilt 2006 · S/N 172S10333 N1287ECrown Coast LLC · Costa Mesa, CABuilt 2006 · S/N 172S10335 N1289YBravo Leasing LLC · Daytona Beach, FLBuilt 2005 · S/N 172S9851 N128SCIasco Flight Training Inc · Redding, CABuilt 1999 · S/N 172S8250 N128SHCalifornia In Nice Inc DBA · San Jose, CABuilt 2020 · S/N 172S12457 N1290FKilm LLC · Wilmington, NCBuilt 2007 · S/N 18282045 N1296MThacker Thomas L Trustee · Hurricane, UTBuilt 2008 · S/N T20608803 N129BAAdvise By Air LLC · Whittier, CABuilt 2004 · S/N 18281353 N129HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2004 · S/N 172S9667 N129JAWhite River Holdings LLC · Hernando, MSBuilt 2022 · S/N 18283172 N129JTNiles Air LLC · Concord, NCBuilt 2024 · S/N 18283288 N129KFf22 LLC · Scottsdale, AZBuilt 2022 · S/N 172S12825 N129SEBarrington Air Inc · Littleton, COBuilt 1998 · S/N 18280384 N129SWRoyal Air LLC · Sarasota, FLBuilt 2018 · S/N 172S12210 N129WSNew Horizon Aviation Inc · Warwick, RIBuilt 2005 · S/N 172S10012 N12EEArizona Cloudbusters Inc · Mesa, AZS/N 18280038 N12HPState Of Ohio · Columbus, OHBuilt 2002 · S/N 18281158 N1305BTriangle Aviators LLC · Cary, NCBuilt 2007 · S/N 172S10654 N1306CWateractive43 LLC · Auburn, CABuilt 2007 · S/N 172S10655 N1306MFreedom Aviation Inc · Lynchburg, VABuilt 2006 · S/N 172S10336

Back to AD 2003-24-13