Skip to content

Registered aircraft · 702

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:2007-11-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-11-21') 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:2007-11-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-11-21')
  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:2007-11-21')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-11-21')
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.

N677AMTactical Integrated Training Solutions LLC · Colorado Springs, COBuilt 2006 · S/N 40.677 N677MTDiamond Aircraft Sales USA Inc · London OntarioS/N 40.1267 N679DSAviation Systems & Service LLC · Mounds, OKBuilt 2006 · S/N 40.679 N681BAQualitair LLC · MichelstadtS/N 40.976 N681DSColyer Christopher A · Moorestown, NJBuilt 2006 · S/N 40.611 N685USBeard Eric D · Bakersfield, CABuilt 2006 · S/N 40.635 N68CVertical Concepts Inc · Wilmington, DEBuilt 2005 · S/N 40.537 N691PSSkywest Leasing Inc · St George, UTBuilt 2006 · S/N 40.691 N691YWGeorge'S Aviation Services Inc · Honolulu, HIBuilt 2006 · S/N 40.690 N692CJFlying High Again LLC · Smyrna, TNBuilt 2012 · S/N 40.1137 N692DSDeltasierra Aero Inc Trustee · Wilmington, DEBuilt 2006 · S/N 40.692 N695DSBravo Busters LLC · Southport, NCBuilt 2007 · S/N 40.865 N704PAUtah State University · Logan, UTBuilt 2006 · S/N 40.704 N706DSRoadside Aviation LLC · Silver Spring, MDBuilt 2007 · S/N 40.858 N707ASCook Todd · South Solon, OHBuilt 2003 · S/N 40.315 N707PSSummit Aviation Inc · Belgrade, MTBuilt 2005 · S/N 40.557 N711YDAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2005 · S/N 40.535 N712PAUtah State University · Logan, UTBuilt 2008 · S/N 40.912 N714KJShortt Aircraft Leasing LLC · South Lyon, MIBuilt 2007 · S/N 40.888 N718DLZhang Boying Barry · Wshngtn Xing, PABuilt 2005 · S/N 40.542 N719MMagnolia Underground Construction Inc · Byhalia, MSBuilt 2007 · S/N 40.851 N71LAHaralson Catherine Laura Kessler · Gadsden, ALBuilt 2005 · S/N 40.471 N720LMTactical Integrated Training Solutions LLC · Colorado Springs, COBuilt 2006 · S/N 40.720 N722PASpoelstra Air LLC · Encinitas, CABuilt 2006 · S/N 40.727 N722STSky Ferry Aircraft Delivery LLC · Wilmington, DEBuilt 2005 · S/N 40.598 N723AGShortt Aircraft Leasing LLC · Wilmington, DEBuilt 2004 · S/N 40.427 N723MGInternational Air Services Inc Trustee · Carson City, NVBuilt 2007 · S/N 40.832 N727CCAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2007 · S/N 40.840 N727MZLmb Aire LLC · Howell, MIBuilt 2004 · S/N 40.435 N728DEMaximize It Consulting LLC · Mesa, AZBuilt 2007 · S/N 40.838 N72MZUtah State University · Logan, UTS/N 40.716 N730DSFoerster James · Carmichael, CABuilt 2007 · S/N 40.737 N731PAMathis John G · South Bend, INBuilt 2006 · S/N 40.731 N732DSCarroll Ian · Washington, DCBuilt 2006 · S/N 40.732 N734MUtah State University · Logan, UTBuilt 2008 · S/N 40.985 N739DSElegantscale LLC · Los Altos, CABuilt 2006 · S/N 40.739 N73LMKrueger Carl R · Put In Bay, OHS/N 40.209 N741CDD & J Training Planes LLC · Logan, UTBuilt 2021 · S/N 40.1230 N741DSSr Fleet Leasing LLC · Mather, CABuilt 2006 · S/N 40.741 N742DSCarling Jaydon S · North Logan, UTS/N 40.326 N744USRyker Debra B Trustee · Long Beach, CABuilt 2006 · S/N 40.724 N745DSSkywest Leasing Inc · Saint George, UTBuilt 2007 · S/N 40.745 N746DSCp LLC · Ooltewah, TNS/N 40.746 N749DSUtah Valley University · Orem, UTBuilt 2007 · S/N 40.749 N74SWUtah State University · Logan, UTBuilt 2007 · S/N 40.828 N752DSCoutale Inc Trustee · Wilmington, DEBuilt 2007 · S/N 40.752 N756DSInternational Air Services Inc Trustee · Carson City, NVBuilt 2004 · S/N 40.361 N759PAUtah State University · Logan, UTBuilt 2008 · S/N 40.929 N760DSPeterson James Brian Trustee · Rch Palos Vrd, CABuilt 2007 · S/N 40.760 N764DSDavis Rod A · Washington, UTBuilt 2007 · S/N 40.764

Back to AD 2007-11-21