Skip to content

Registered aircraft · 7,870

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.

N175CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282337 N175MENorth Perry Flight Center Inc · Fort Lauderdale, FLBuilt 2000 · S/N 172S8437 N1760TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12108 N1762TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12109 N1766TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12110 N176BLChristiansen Aviation LLC · Wilmington, DEBuilt 2013 · S/N 172S11287 N176CPCivil Air Patrol · Maxwell Afb, ALBuilt 2011 · S/N T20609001 N176MEEastern Cincinnati Aviation Inc · Batavia, OHBuilt 2000 · S/N 172S8470 N176TAGeorge'S Aviation Services Inc · Honolulu, HIBuilt 2018 · S/N 172S12115 N1774TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12111 N177CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282338 N177VZCollinair LLC · Coppell, TXBuilt 2011 · S/N T18209024 N1781TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12112 N1782TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12113 N1788TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12114 N178AFSoutheast Aircraft Leasing LLC · Jacksonville, FLBuilt 2003 · S/N 17281177 N178CPCivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13039 N178GWBravo Aircraft LLC · Ooltewah, TNBuilt 2020 · S/N 172S12491 N178JMDcd Aviation LLC · Heber, CABuilt 2006 · S/N T18208534 N179CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282339 N179DMNg Research · Bristow, VABuilt 2015 · S/N T20609179 N179JSMcdonald Timothy Steven · Slaton, TXBuilt 2004 · S/N 18281481 N179MEFlight Rt LLC · Thonotosassa, FLBuilt 2000 · S/N T20608184 N179VBAdl Tracey LLC · Warrenton, VABuilt 2013 · S/N T18209079 N17BBTextron Aviation Inc · Wichita, KSS/N T20609861 N17BMNavigation Leasing LLC · Castle Rock, COBuilt 2023 · S/N 172S12978 N17GMNorthwestern Michigan College · Traverse City, MIBuilt 2021 · S/N 172S12769 N17HPState Of Ohio Dept Of Public Safety · Columbus, OHBuilt 2004 · S/N 18281436 N17MVNorthwestern Michigan College · Traverse City, MIBuilt 2020 · S/N 172S12598 N17SJAnson Air LLC · Sugar Land, TXBuilt 1999 · S/N 172S8344 N17YRNagle Jeffrey · Fremont, INS/N 18282456 N1806MCareer Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13177 N180BWJ&B Flight Service LLC · Brownsville, TXBuilt 2006 · S/N T18208552 N180CPCivil Air Patrol · Maxwell Afb, ALBuilt 2021 · S/N 172S12727 N180KHPwx Services · Bristow, VABuilt 2015 · S/N T20609180 N180SUOhio State University · Columbus, OHBuilt 2018 · S/N 172S12161 N1810SSwift Current Resources LLC · Billings, MTS/N T18208433 N1812EAtp Aircraft 6 LLC · Wilmington, DEBuilt 2018 · S/N 172S12168 N1815UJanson James A · Eagle, IDBuilt 2005 · S/N T18208434 N1817EAtp Aircraft 6 LLC · Wilmington, DEBuilt 2018 · S/N 172S12169 N181CSElkhorn Valley Trucks II LLC · Fremont, NEBuilt 2024 · S/N 18283280 N181GSTravel Services LLC · Metropolis, ILBuilt 2006 · S/N T18208499 N181LBWatts Rodney · Hot Springs, SDBuilt 2006 · S/N T18208666 N181MECoastal Marine Engine Inc · Seattle, WABuilt 2000 · S/N T20608182 N181MWCsa Aircraft Leasing LLC · Salt Lake City, UTBuilt 1997 · S/N 17280181 N181SATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 20608192 N181SCAlpha Charlie Aviation LLC · Oregon City, ORBuilt 2016 · S/N 172S11663 N181TWTom Wood Aviation Inc · Fishers, INBuilt 2026 · S/N 172S13549 N1820EAtp Aircraft 6 LLC · Wilmington, DEBuilt 2018 · S/N 172S12170 N1821ZTubbs George L · Colby, KSBuilt 2005 · S/N T18208435

Back to AD 2003-24-13