Skip to content

AD 2003-05-10 R1

Registered aircraft · 1,108

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-05-10-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:2003-05-10-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:2003-05-10-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:2003-05-10-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:2003-05-10-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:2003-05-10-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.

N605JPJmp 605 LLC · Miami, FLBuilt 2012 · S/N 5919 N605LCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 5740 N605LFLevel Flight LLC · Jefferson City, MOBuilt 2009 · S/N 5794 N605LTWeyerhaeuser Nr Co · Seattle, WABuilt 2012 · S/N 5923 N605MMAa Not E LLC · New York, NYBuilt 2008 · S/N 5769 N605NSFalcon Aviation & Jet Sales LLC · Parrish, FLBuilt 2009 · S/N 5806 N605PATvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 5753 N605RBAircraft Trust & Financing Corp Trustee · Wilmington, DEBuilt 2009 · S/N 5791 N605RTMountaingate LLC · Jackson, WYBuilt 2012 · S/N 5917 N605TKRoberts Asset Management Corp · Boston, MABuilt 2010 · S/N 5854 N605TRTarco Aircraft Funding LLC · Fort Lauderdale, FLBuilt 2007 · S/N 5715 N605VVSw Automotive Management Holdings LLC · Highlands Ranch, COBuilt 2008 · S/N 5773 N606JLRegistered aircraftBuilt 1997 · S/N 5332 N609SKSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 10020 N60BSBravo-Fox LLC · Atlanta, GABuilt 2010 · S/N 5834 N610LValiair Lc Trustee · Casper, WYBuilt 2005 · S/N 5607 N611ABPollard Spares LLC · Roanoke, TXBuilt 1997 · S/N 5324 N611AZPaloma & Joan LLC · Dover, DEBuilt 2005 · S/N 5637 N611SKSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 10035 N612QXSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 10042 N613JRGlobal Aviation Network LLC · Allentown, PABuilt 2016 · S/N 6070 N613SKSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 10038 N614PJJem Leasing LLC · Etna, OHBuilt 2008 · S/N 5776 N614QXSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 10049 N614SGTsg Holdings Company Ga LLC · Atlanta, GABuilt 1997 · S/N 5343 N614SKSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 10051 N615BNOnward And Upward Aviation LLC · New York, NYBuilt 2008 · S/N 5762 N617BWWhite Aviation Holdings LLC · Boston, MABuilt 2003 · S/N 5572 N618CRLeidos Inc · Reston, VABuilt 2001 · S/N 5520 N618JJJj Challenger 620tm LLC · Wilmington, DEBuilt 1999 · S/N 5440 N61FFPayne Aviation Weslaco LLC · Weslaco, TXBuilt 1994 · S/N 5166 N620PJFth Acquisition Corp Vii · Richardson, TXNon-citizen corporation, flight hours not reportedBuilt 1994 · S/N 5169 N621DJNorth Point Aviation LLC · San Francisco, CABuilt 1994 · S/N 5144 N622DDanforth LLC · Columbus, OHBuilt 2020 · S/N 6161 N622HAHamilton Aviation Inc · Portland, ORBuilt 2025 · S/N 6224 N622JDMusashi Jets LLC · Del Valle, TXBuilt 1998 · S/N 5356 N624MYWhitehawk Holdings LLC · Tulsa, OKBuilt 2013 · S/N 5958 N625CASkywest Airlines Inc · St George, UTBuilt 2003 · S/N 10113 N626KSHoltec Logistics LLC · Camden, NJBuilt 2013 · S/N 5952 N627AFAmerican Fidelity Corp · Oklahoma City, OKBuilt 2002 · S/N 5548 N628EFSn 5024 Corp · Fort Lauderdale, FLBuilt 1988 · S/N 5024 N628GLXxx Ventures LLC · Austin, TXBuilt 2017 · S/N 6108 N629HGHantz Air LLC · Southfield, MIBuilt 2011 · S/N 5880 N629SYSkywest Airlines Inc · Saint George, UTBuilt 2024 · S/N 17000986 N62HAJn Equipment Leasing LLC · Seymour, CTBuilt 2012 · S/N 5925 N630ARAar International Financial Services LLC · Wood Dale, ILBuilt 2009 · S/N 5797 N633WMCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 5951 N638RWRepublic Airways Inc · Carmel, INBuilt 2004 · S/N 17000053 N639RWRepublic Airways Inc · Carmel, INBuilt 2004 · S/N 17000057 N640GRDodson International Parts Inc · Rantoul, KSS/N 5093

Back to AD 2003-05-10 R1