Registered aircraft · 6,038

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.

N925PTPuddle Jumper Aviation LLC · Saginaw, MIBuilt 2003 · S/N 18281217 N925YZFranchetti Kevin · Manchester, MEBuilt 2005 · S/N 172S9869 N926AMGlisson Susan M · Evansville, INBuilt 2001 · S/N 172S8772 N926CPCivil Air Patrol · Maxwell Afb, ALBuilt 2001 · S/N 172S8914 N926CRAero Tech Services Inc · Lititz, PABuilt 2020 · S/N 172S12537 N926JAMustang Sally Aviation LLC · Camden, SCBuilt 2009 · S/N 172S10926 N926NLRemington Robert J · Sheboygan Falls, WIS/N 172S8812 N927AZN927az LLC · Miami, FLBuilt 2002 · S/N 172S9090 N927CPCivil Air Patrol · Maxwell Afb, ALBuilt 2001 · S/N 172S8915 N927GHB R S Leasing Inc · Wilmington, DEBuilt 2005 · S/N 172S10024 N927GPChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 172S12409 N927PCBillington Seabird LLC · Norman, OKBuilt 2006 · S/N T18208624 N927TSM & G Aircraft Management LLC · Aurora, ORBuilt 2023 · S/N 172S13067 N9280TChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 172S12413 N9281ABuiqui Aerospace Corp · Kissimmee, FLBuilt 2022 · S/N 172S12787 N9283AFf22 LLC · Scottsdale, AZBuilt 2022 · S/N 172S12788 N9287MRkm Leasing LLC · Greenwich, CTBuilt 2011 · S/N 172S11112 N928CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 18282396 N928FGMustang Sally Aviation LLC · Camden, SCBuilt 2006 · S/N 172S10371 N928LPMontana Freedom Riders LLC · Corvallis, MTBuilt 2001 · S/N 172S8928 N928MAAnson Air LLC · Sugar Land, TXFirst renewal noticeBuilt 1999 · S/N 17280785 N928ZAFf22 LLC · Scottsdale, AZBuilt 2022 · S/N 172S12786 N92959Warar Manjit Singh · Shreveport, LABuilt 2011 · S/N T18209046 N92970Elizabeth City State University · Elizabeth City, NCBuilt 2011 · S/N 172S11124 N92FSEastern Kentucky University · Richmond, KYBuilt 1998 · S/N 17280308 N92HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2000 · S/N 172S8642 N92LCEastern Kentucky University · Richmond, KYBuilt 1997 · S/N 17280153 N92VBClear Skies LLC · Eugene, ORBuilt 2013 · S/N T18209092 N92ZSky Galaxy 1 LLC · Lake Placid, NYBuilt 2008 · S/N T18208841 N9303NWings Over Texas Holdings LLC · Denton, TXBuilt 2011 · S/N 172S11118 N9305NRancho Av Leasing LLC · Temecula, CABuilt 2011 · S/N 172S11132 N9309CVan Bortel Aircraft Inc · Arlington, TXBuilt 2011 · S/N 18282306 N930BMCoastal Aviation LLC · Nags Head, NCBuilt 2009 · S/N T18208980 N930CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 18282398 N9318WAutoscribe Arrow LLC · Fort Lauderdale, FLBuilt 2011 · S/N T18209051 N931VMVermeer Great Plains Inc · Olathe, KSBuilt 2011 · S/N T18209054 N9324FKrueger Michael L D O · Fresno, CABuilt 2011 · S/N T18209055 N932FGTextron Aviation Inc · Wichita, KSS/N 172S13645 N933CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 18282399 N933CSTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 18283333 N933LAMindy Limited LLC · Muscatine, IABuilt 1998 · S/N 17280640 N9342TChristiansen Aviation LLC · Wilmington, DEBuilt 2011 · S/N 172S11153 N9344FAtp Aircraft 2 LLC · Wilmington, DEBuilt 1997 · S/N 17280166 N9347TLewis University · Romeoville, ILBuilt 2012 · S/N 172S11166 N9348FDirty Side Down Aviation LLC · Georgetown, TXBuilt 1997 · S/N 17280189 N934AZN934az LLC · Miami, FLBuilt 1999 · S/N 172S8294 N934CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 18282400 N934EREmbry Riddle Aeronautical University · Daytona Beach, FLBuilt 2023 · S/N 172S12982 N934MT8th Dimension Enterprises LLC · Englewood, COBuilt 1997 · S/N 17280058 N93517Pjc700 LLC · Las Vegas, NVBuilt 2012 · S/N T18209066

Back to AD 2005-05-53 R1