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.

N611MHAwesome Aero LLC · South Plainfield, NJBuilt 2004 · S/N 40.408 N614DSBcd Leasing Corp · Lexington, KYBuilt 2005 · S/N 40.601 N615DVLunada Bay Dental Practice Dyan Van De Velde Dmd · Pls Vrds Est, CABuilt 2005 · S/N 40.470 N616MLUtah State University · Logan, UTBuilt 2009 · S/N 40.1067 N617RTAccess Aero LLC · Manakin Sabot, VABuilt 2011 · S/N 40.1114 N61KMFly US Corp · Lewes, DEBuilt 2006 · S/N 40.675 N61LHFive Star Marketing Inc · Morrisville, NCBuilt 2004 · S/N 40.415 N622DSMidwest Corporate Air Inc · Bellefontaine, OHBuilt 2006 · S/N 40.612 N623DSFirst Western Capital Corp · Rllng Hls Est, CABuilt 2010 · S/N 40.1076 N623MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2026 · S/N 40.1260 N624DSBcd Leasing Corp · Lexington, KYBuilt 2006 · S/N 40.624 N626QSkywest Leasing Inc · Saint George, UTBuilt 2007 · S/N 40.843 N626TTonkawa Road Holdings LLC · Wayzata, MNBuilt 2005 · S/N 40.544 N633DCRitchie Holdings LLC · Yorktown, VABuilt 2008 · S/N 40.940 N633DSIn Flight Aircraft LLC · Howell, MIBuilt 2006 · S/N 40.613 N635ATTdjb LLC · Tamarac, FLBuilt 2005 · S/N 40.578 N635DSPonici Adrian · East Hanover, NJBuilt 2006 · S/N 40.615 N636ATJr Aircraft Services LLC · Oxford, MIBuilt 2005 · S/N 40.588 N638DSSkywest Leasing Inc · St George, UTS/N 40.738 N63WPRenno Aero LLC · Ann Arbor, MIBuilt 2005 · S/N 40.498 N643DSDs Air LLC · Jefferson, GABuilt 2006 · S/N 40.643 N644DSFitzroy Aviation LLC · San Francisco, CABuilt 2006 · S/N 40.614 N645WTBourne & Bourne Enterprise LLC · Atlanta, GABuilt 2007 · S/N 40.836 N647DSSkyshare LLC · Prescott, AZBuilt 2006 · S/N 40.647 N648DSAmerican Asset Leasing LLC · Aurora, ORBuilt 2006 · S/N 40.616 N64SUEllison Stephen R · Lampasas, TXBuilt 2008 · S/N 40.994 N653DSLucy LLC · Fairhope, ALBuilt 2007 · S/N 40.853 N653JSTidewater Flying Club Inc · Newport News, VAS/N 40.323 N654MRlw Wholesale LLC · Myrtle Beach, SCBuilt 2004 · S/N 40.412 N654MSIndiana State University · Terre Haute, INBuilt 2007 · S/N 40.842 N655DSSky Safety Inc · San Antonio, TXBuilt 2006 · S/N 40.661 N655NABcd Leasing Corp · Lexington, KYBuilt 2006 · S/N 40.655 N656BBAnderson Barry A · West Branch, IABuilt 2007 · S/N 40.859 N656BCSky Safety Inc · San Antonio, TXBuilt 2004 · S/N 40.441 N656BGIowa Aerotech LLC · Spirit Lake, IABuilt 2006 · S/N 40.735 N657DSAdamas Marketing LLC · Indianapolis, INBuilt 2007 · S/N 40.852 N658DSKelly Brian · New York, NYBuilt 2006 · S/N 40.662 N660PS8th Dimension Enterprises LLC · Aurora, ORBuilt 2006 · S/N 40.660 N661DSG & R Holdings LLC · Arcadia, CABuilt 2005 · S/N 40.600 N661MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2025 · S/N 40.1261 N662DSPilot Plase LLC · Sarasota, FLBuilt 2006 · S/N 40.632 N662MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2025 · S/N 40.1262 N668DSInternational Air Services Inc Trustee · Carson City, NVBuilt 2004 · S/N 40.368 N669PSAugust 98 Aviation LLC · Mclean, VABuilt 2006 · S/N 40.699 N672DSAisle One Aviation LLC · Towson, MDBuilt 2006 · S/N 40.672 N673DADragonfly Aviation LLC · Winder, GABuilt 2006 · S/N 40.673 N674MTDiamond Aircraft Sales U S A Inc · London OntarioS/N 40.1268 N675MTMiddle Tennessee State University · Murfreesboro, TNS/N 40.1265 N676MTMiddle Tennessee State University · Murfreesboro, TNS/N 40.1266 N676USMiddle Tennessee State University · Murfreesboro, TNBuilt 2006 · S/N 40.676

Back to AD 2007-11-21