Skip to content

Registered aircraft · 3,260

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

N100AGDodson Intl Parts Inc · Rantoul, KSBuilt 2005 · S/N 258747 N100ARIndependence Aircraft Inc · Manchester, NHBuilt 2002 · S/N 560-5241 N100CJDouble Force Management LLC · Bowling Green, KYBuilt 2000 · S/N 560-5100 N100FKFk Air LLC · Newark, DEBuilt 2000 · S/N 113 N100HLRail Transloading Services LLC · San Antonio, TXBuilt 1997 · S/N 258345 N100KZLear 100kz LLC · Austin, TXBuilt 1999 · S/N 065 N100RPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 9450 N100SC560 Inc Trustee · Chattanooga, TNBuilt 2013 · S/N 560-6141 N100SYAerodan Aviation LLC · Alpharetta, GABuilt 1990 · S/N 560-0054 N100UJSistares Property LLC · Statesville, NCBuilt 1999 · S/N 3118 N100WPTads LLC · Kansas City, KSBuilt 1990 · S/N 560-0073 N100YBEng Capital LLC · Coppell, TXS/N 560-5136 N10156United Airlines Inc · Chicago, ILBuilt 2004 · S/N 145786 N1019LRegistered aircraftBuilt 2003 · S/N 9125 N101ERRl Trasnportation Co Ix LLC · Upland, CABuilt 2014 · S/N 560-6179 N101WDMiwd Flight LLC · Middletown, PABuilt 2020 · S/N 560-6286 N101WYWyoming Department Of Transportation · Cheyenne, WYS/N 560-0620 N1023CAero Aircraft Holdings II LLC · Van Nuys, CABuilt 2001 · S/N 145550 N1027JMagic Carpet LLC · Wilmington, DES/N 560-0564 N102VPPrioritylab LLC · Indianapolis, INBuilt 2002 · S/N 560-0629 N102WYWyoming Department Of Transportation · Cheyenne, WYS/N 560-0621 N1036S1036s LLC · Austin, TXBuilt 2005 · S/N 258704 N103BZJet Way LLC · Brooklyn, OHBuilt 2002 · S/N 560-0617 N103EZ103ez LLC · Champaign, ILBuilt 2011 · S/N 418 N103GRGrc Aviation LLC · Lynchburg, VABuilt 2003 · S/N 560-5327 N103MLPerfect Agreements Leasing Inc · Trabuco Canyon, CABuilt 2002 · S/N 560-5244 N103SWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2003 · S/N 9129 N104DATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 9266 N104EJAlliance Aviation Group LLC · Wilmington, DEBuilt 2000 · S/N 258505 N104LRTri Aviation Inc · Venetia, PABuilt 1996 · S/N 258303 N104VPJdlfox Transportation LLC · Missoula, MTBuilt 2002 · S/N 560-0619 N105BGC & K Aviation Services LLC · Wilmington, DEBuilt 1995 · S/N 560-0315 N105RHJem Aviation Solutions LLC · South River, NJBuilt 1984 · S/N 650-0055 N105TDJcd-Gp LLC · Center, TXBuilt 2002 · S/N 560-0632 N106ECAurogold Aviation Inc Trustee · Wilmington, DEBuilt 2009 · S/N 14501106 N106GKVrs Holdings LLC · Medina, OHBuilt 2013 · S/N 2134 N106PGGreco Equipment Leasing LLC · Bartlett, ILBuilt 1993 · S/N 650-7012 N106VPTeam Aero LLC · Shawnee, KSBuilt 2002 · S/N 560-0628 N1088RHampton Railway LLC · Eugene, ORBuilt 2013 · S/N 560-6156 N108KNStuckey Connections LLC · Magnolia, TXBuilt 2007 · S/N 336 N108RLShamrock Aero LLC · Liberty, NCBuilt 2003 · S/N 258619 N108VRDraughn Aviation LLC · Salado, TXBuilt 2002 · S/N 560-0601 N1098LLasai Aviation II LLC · Manassas, VABuilt 2023 · S/N 60098 N109LWWeisbrod & Weisbrod Pc · Dallas, TXBuilt 2000 · S/N 071 N10HCKba LLC · Dover, DEBuilt 2008 · S/N 14501080 N10JMov Aviation LLC · Wilmington, DEBuilt 2007 · S/N 337 N10NLO Neal Industries Inc · Birmingham, ALBuilt 2000 · S/N 128 N10PHBlue Sky Harbour LLC · Hummelstown, PABuilt 2013 · S/N 560-6142 N10QS25p150c LLC · Oklahoma City, OKBuilt 2026 · S/N 560-6507 N10TDPrairie Air LLC · Aberdeen, SDBuilt 1991 · S/N 560-0096

Back to AD 2006-22-05