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.

N216DGSky Safety Inc · San Antonio, TXBuilt 2006 · S/N 40.698 N216GTFlying Cow LLC · Jenks, OKBuilt 2007 · S/N 40.819 N217CFN47hy LLC · New York, NYBuilt 2005 · S/N 40.584 N218CLBlue Diamond Marketing LLC · Hoover, ALBuilt 2011 · S/N 40.1129 N218DCGammons Leasing LLC · North Charleston, SCBuilt 2008 · S/N 40.965 N218DSCapital Holdings 201 LLC · Waynesboro, PABuilt 2008 · S/N 40.951 N218WLN218wl LLC · Marshalltown, IABuilt 2004 · S/N 40.387 N219DSJojo & Dino Ltd · Frederick, MDBuilt 2002 · S/N 40.219 N222ADShroomdom Inc · Poplarville, MSBuilt 2006 · S/N 40.653 N222GFFischer Edward T · Appleton, WIBuilt 2002 · S/N 40.230 N223DSCatalane Air LLC · Sewickley, PABuilt 2002 · S/N 40.223 N224BSHoff Brian D · Spearfish, SDFirst renewal noticeBuilt 2004 · S/N 40.428 N224WMSchock Steven W · Huntington Beach, CAS/N 40.538 N226PAF & S Aviation LLC · Cary, NCBuilt 2010 · S/N 40.1087 N2287AGiacopassi Dean · Newport News, VABuilt 2002 · S/N 40.226 N22QQSkywest Leasing Inc · St George, UTBuilt 2004 · S/N 40.447 N22QTAlameda Aero Club · Alameda, CABuilt 2005 · S/N 40.491 N230DCUtah State University · Logan, UTBuilt 2008 · S/N 40.966 N230DSWestward Wind Ltd · Wilmington, DEBuilt 2005 · S/N 40.599 N231DSFolkvord Svein · Brighton, MIBuilt 2007 · S/N 40.830 N232BBKimbrough Aviation LLC · Oakwood, OHBuilt 2005 · S/N 40.531 N232DSSmith William · Colorado Springs, COBuilt 2005 · S/N 40.553 N232TXHaugo Bruce · Sarasota, FLBuilt 2008 · S/N 40.991 N233AMHsing Mitchell · Saratoga, CABuilt 2006 · S/N 40.733 N233MAMidwest Corporate Air Inc · Bellefontaine, OHBuilt 2005 · S/N 40.511 N236DSLoberg Kirk · Jonesboro, ARS/N 40.271 N236MABountiful Flight LLC · Woods Cross, UTBuilt 2004 · S/N 40.425 N236SDMoss Steven · Las Vegas, NVBuilt 2006 · S/N 40.696 N237DSYoung Mark K · Charleston, WVBuilt 2005 · S/N 40.592 N238DCKick Tires Light Fires LLC · Seattle, WABuilt 2008 · S/N 40.967 N239DCUtah State University · Logan, UTBuilt 2008 · S/N 40.968 N239DSEmley Tyler E · Hebron, INBuilt 2007 · S/N 40.831 N239MAHeath Robert D · Locust Grove, GABuilt 2005 · S/N 40.512 N242GLPremier Real Estate Services LLC · Saint Cloud, MNBuilt 2011 · S/N 40.1125 N242YAerospace Development Group Inc · Trinity, FLBuilt 2004 · S/N 40.404 N243DSPffc LLC · Lynden, WABuilt 2003 · S/N 40.325 N244SFKitsune Air LLC · Wilmington, DEBuilt 2005 · S/N 40.558 N245DSTactical Integrated Training Solutions LLC · Colorado Springs, COBuilt 2007 · S/N 40.833 N247CDMiddle Tennessee State University · Murfreesboro, TNBuilt 2014 · S/N 40.1193 N247DSNetwork Spares LLC · Wilmington, DEBuilt 2011 · S/N 40.1117 N248DSMichiana Air Activities Inc · Osceola, INBuilt 2011 · S/N 40.1118 N249DSMountain Aviation LLC · Salem, VABuilt 2002 · S/N 40.249 N250CBMaitland Scott · Chapel Hill, NCBuilt 2002 · S/N 40.236 N252AXFrequency Change Aviation Services Inc · Nashville, TNBuilt 2004 · S/N 40.392 N257DSGlazier Enterprises LLC · Reno, NVBuilt 2003 · S/N 40.265 N258DSCooper James K II · Madisonville, KYBuilt 2008 · S/N 40.1016 N261DSAerolus LLC · Fairfax, VABuilt 2008 · S/N 40.924 N262DSCerebral Aviation LLC · Oakwood, OHBuilt 2012 · S/N 40.1161 N263DSFalconer Steven Charles · El Dorado Hills, CAS/N 40.263 N264DSSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2007 · S/N 40.864

Back to AD 2007-11-21