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.

N309GMScroggins Aero LLC · Cabot, ARBuilt 2022 · S/N 18283166 N309SPSchaumburg Flying Club Nfp · Palatine, ILBuilt 1999 · S/N 172S8245 N309TXCareer Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13230 N30SUOhio State University · Columbus, OHBuilt 2015 · S/N 172S11625 N30TLElite Approach LLC · Chesterfield, MOBuilt 2006 · S/N 172S10183 N30YPBmf Jax LLC · Jacksonville, FLBuilt 2012 · S/N 17281600 N30YRInn Flying Club Inc · Gaithersburg, MDBuilt 1997 · S/N 17280043 N311JMN311jm LLC · Lake City, FLBuilt 2007 · S/N 18281891 N311KPPickard Kevin P · Washington, MIBuilt 2023 · S/N 18283230 N311SBNbr Aviation · Manassas, VAFirst renewal noticeBuilt 2010 · S/N 18282246 N312PDValdosta Flying Service Inc · Valdosta, GABuilt 2000 · S/N 172S8408 N312XYAir Surgeon I LLC · Miami, FLBuilt 2023 · S/N 18283222 N313AAAviator Air Operations LLC · Grand Prairie, TXBuilt 2013 · S/N 172S11286 N313CPCivil Air Patrol · Maxwell Afb, ALBuilt 2009 · S/N 18282187 N313ECCunha Properties Management LLC · Miami, FLBuilt 2011 · S/N T18209052 N313RMVan Bortel Aircraft Inc · Arlington, TXBuilt 2005 · S/N T18208456 N313YZTextron Aviation Employees' Flying Club Inc · Wichita, KSBuilt 2024 · S/N 172S13179 N3144VMike Smith Aviation International Inc · Napa, CABuilt 2002 · S/N 172S9123 N314LARaintree Aviation LLC · Mesa, AZBuilt 2013 · S/N 172S11285 N314RARochester Air Center LLC · Canandaigua, NYBuilt 1998 · S/N 17280489 N314SAAeryn Innovations LLC · Dallas, TXBuilt 2003 · S/N 18281243 N315DMSpartan Education LLC · Tulsa, OKBuilt 2004 · S/N 172S9574 N315GFCommander Aviation LLC · New Holland, ILBuilt 2023 · S/N T18209103 N315MEBlue Horizons Flying Club Inc · Perrysburg, OHBuilt 2000 · S/N 172S8560 N315SFSnohomish Flying Service Inc · Snohomish, WABuilt 2023 · S/N 172S13015 N315SKOklahoma Aviation LLC · Bethany, OKBuilt 2015 · S/N 172S11573 N315TPN315tp LLC · Stuart, FLBuilt 1999 · S/N 172-80809 N316ADRude Daniel · Leesburg, VABuilt 2023 · S/N T18209112 N316ASChristiansen Aviation LLC · Wilmington, DEBuilt 2005 · S/N 172S9810 N316DCAb Prop Plane II LLC · Metairie, LABuilt 2022 · S/N 172S12899 N316EPMustang Sally Aviation LLC · Camden, SCBuilt 2016 · S/N 172S11682 N316HCChilders Henry Dr · Lewes, DEBuilt 2024 · S/N 18283270 N316JHNorthern Arizona Investment Group LLC · Prescott, AZBuilt 2004 · S/N 18281345 N316RBRbp Management LLC · Franklin, NCBuilt 2008 · S/N T18208813 N317BLCowboy Aviation LLC · Edmond, OKFirst renewal noticeBuilt 2020 · S/N 172S12466 N317BTAmerican Aircraft Brokers LLC · Aurora, ORBuilt 2005 · S/N 172S9828 N317CPCivil Air Patrol · Maxwell Afb, ALBuilt 2020 · S/N 172S12515 N317HDHardrock Drilling LLC · Francesville, INBuilt 2026 · S/N 18283339 N318LLLee Aviation Services LLC · Wilson, NCBuilt 2024 · S/N 18283287 N318SJObr Leasing · Manassas, VAFirst renewal noticeBuilt 2010 · S/N 18282251 N318WCDelta Dusters LLC · Lake Providence, LABuilt 2006 · S/N 18281829 N319EPEpic Aviation Inc · New Smyrna, FLBuilt 2019 · S/N 172S12277 N319KSFvx Research · Manassas, VABuilt 2010 · S/N 18282243 N319MEN319me LLC A Series Of Aero Lease LLC · San Antonio, TXBuilt 2000 · S/N 172S8564 N31ABEtanrith Consulting LLC · Sheldon, SCBuilt 2021 · S/N 18283143 N31CWVolar III LLC · Edmond, OKBuilt 2023 · S/N 172S12956 N31DGGrommeck Aviation LLC · Steamboat Springs, COBuilt 2024 · S/N T18209163 N31MJN31mj LLC · Naples, FLBuilt 2020 · S/N 18283118 N320MECall The Ball Aviation LLC · Phoenix, AZBuilt 2000 · S/N 172S8565 N320RCEastern Properties LLC · Burlington, NJBuilt 2004 · S/N 18281352

Back to AD 2005-05-53 R1