Registered aircraft · 6,034

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:2005-05-53-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:2005-05-53-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:2005-05-53-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:2005-05-53-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:2005-05-53-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:2005-05-53-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.

N122JAChase James P · Waco, TXBuilt 2025 · S/N 18283320 N122VKWings Over Texas Holdings LLC · Denton, TXBuilt 2005 · S/N 172S9856 N122WEOhio State University · Columbus, OHBuilt 2019 · S/N 172S12396 N1230BM&M Modal LLC · Denver, COBuilt 2007 · S/N T18208675 N1230GFlight Training Aircraft LLC · Wilmington, DEBuilt 2005 · S/N 172S9838 N1232EVan Bortel Aircraft Inc · Arlington, TXBuilt 2007 · S/N T18208777 N1232GDirty Side Down Aviation LLC · Georgetown, TXBuilt 2002 · S/N 172S9095 N1232XGehrett Clifford Rooks · Sammamish, WABuilt 2007 · S/N T18208676 N1235ESale Reported · Lewes, DESale reportedS/N 172S9847 N12386Fly White Cloud LLC · Lake Havasu City, AZS/N 172S9857 N123CPCivil Air Patrol · Maxwell Afb, ALBuilt 2026 · S/N 172S13483 N123GG150th Aero Flying Club · Morristown, NJBuilt 2004 · S/N 172S9600 N123GHMoyers Jeff · Troy, VABuilt 2002 · S/N T18208105 N123JSBlue Sky Ventures LLC · Bridgeport, CTS/N T18208053 N123PBTextron Aviation Inc · Wichita, KSS/N 172S13648 N123PFJet Air Inc · Iowa City, IABuilt 1999 · S/N 172S8086 N123TZSouthside Truck And Trailer Inc · San Antonio, TXBuilt 2004 · S/N 18281327 N123VKAtp Aircraft 1 LLC · Wilmington, DEBuilt 2006 · S/N 172S10121 N12419Fort Wayne Aircraft LLC · Fort Wayne, INBuilt 2006 · S/N 172S10306 N1242BMustang Sally Aviation LLC · Camden, SCBuilt 2006 · S/N 172S10307 N1242NBg-Ip LLC · Saratoga, CABuilt 2006 · S/N 172S10309 N1243NZenisek Andrew F · Sioux Falls, SDBuilt 2006 · S/N T18208642 N1247VSchwartz Mark S · Woodbury, NYBuilt 2006 · S/N T18208643 N1248EBoling Derek · Paragould, ARBuilt 2005 · S/N 18281590 N124BSLeair LLC · Eufaula, ALBuilt 2004 · S/N 18281390 N124CKChristiansen Aviation LLC · Wilmington, DEBuilt 2005 · S/N 172S9808 N124HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2004 · S/N 172S9632 N124KYMozzie Air LLC · Tampa, FLBuilt 2005 · S/N T18208453 N124MEJet Air Inc · Iowa City, IABuilt 2000 · S/N 172S8372 N124PLL & W Leasing LLC · Smyrna, TNBuilt 1999 · S/N 172S8194 N124SKAgarwal Sanjai K · Monroe, NJBuilt 2025 · S/N 18283304 N124WEMidwest Aviation Inc · Mayfield, KYBuilt 2019 · S/N 172S12393 N124WJSessions Thomas Eric Trustee · Huffman, TXBuilt 2004 · S/N 18281475 N124WMDenton James Manley Jr · Cabot, ARBuilt 2016 · S/N 18282431 N1250KChristiansen Aviation LLC · Wilmington, DEBuilt 2023 · S/N 172S13050 N1251DErjoaero LLC · Stuart, FLBuilt 2007 · S/N 18282023 N1254DAmeriflyers Of Texas Inc · Addison, TXBuilt 2006 · S/N 172S10127 N1257P812 Aviation LLC · Salem, INBuilt 2022 · S/N 18283193 N125AHPray Ricky Lee Trustee · Woodland Hills, UTS/N T18208240 N125AKBaize Equipment LLC · Crawford, TXBuilt 2004 · S/N T18208320 N125JABillmans Inc · Cut Bank, MTBuilt 2005 · S/N 18281527 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 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

Back to AD 2005-05-53 R1