Registered aircraft · 11,798

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-16-18-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:2006-16-18-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:2006-16-18-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:2006-16-18-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:2006-16-18-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:2006-16-18-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.

N3177NBcs99 LLC · Peoria, ILBuilt 1988 · S/N E-2440 N3177WCraniatwo LLC · Peoria, ILBuilt 2000 · S/N TH-1967 N3178AMarine Aviation LLC · New Bedford, MABuilt 1970 · S/N TH-3 N3178VHowell Larry A · Terrell, TXBuilt 1947 · S/N D-612 N317CQPrivate Fliers LLC · Wheaton, ILBuilt 2001 · S/N 258532 N317FPMarbella Blue LLC · Austin, TXBuilt 2022 · S/N FL-1295 N317PGAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 33344 N3181VSitkins Amber A · Ozark, MOBuilt 1947 · S/N D-616 N3182LN303cj LLC #1 · Lexington, KYBuilt 1999 · S/N TH1882 N3185CThree Pipers Piping LLC · Charleston, SCBuilt 2000 · S/N E-3324 N3187WG S Aviation Inc · Stilwell, KSBuilt 1974 · S/N TH-428 N3189MSnowbird Aviation Corp · Signal Mountain, TNBuilt 2000 · S/N E-3325 N3189YSkotynsky Michael · Broomfield, COBuilt 2001 · S/N E-3389 N318CAKornegay Patrick · Harlingen, TXBuilt 2001 · S/N TH-2001 N318CBBrown Flight Properties LLC · Midland, TXBuilt 2000 · S/N BB-1730 N318CGSvp LLC · Missoula, MTBuilt 1999 · S/N 525-0323 N318CTJr & M Air LLC · San Antonio, TXBuilt 1990 · S/N 560-0081 N318ELExpress Leasing LLC · Richmond, VABuilt 2008 · S/N FL582 N318FLUmb Bank Na Trustee · Salt Lake City, UTBuilt 2000 · S/N 28318 N318JSilver Eagle LLC · Kenedy, TXBuilt 2003 · S/N E-3526 N318JHAir Hoffmann LLC · Saint Louis, MOBuilt 2014 · S/N 525-0817 N318JPSurric LLC · Shreveport, LABuilt 2024 · S/N 525-1174 N318RWMueller Aero Inc · Prairie Du Sac, WIBuilt 1990 · S/N 560-0051 N3190VTop Flight LLC · Wilmington, DEBuilt 1947 · S/N D-626 N3191APasternak Eliezer Trustee · Palo Alto, CABuilt 1999 · S/N E-3291 N3192WJ M Beech Inc · Wilmington, DEBuilt 1974 · S/N E-521 N3193XBlh Visions Mt LLC · Polson, MTBuilt 1994 · S/N E-2907 N3194XAutry Mark T · Sumter, SCBuilt 1994 · S/N TH-1723 N3195KEasygoair LLC · Sudbury, MABuilt 1999 · S/N TH-1895 N3195XAirbonanza LLC · Fort Myers, FLFirst renewal noticeS/N E-3295 N3196AKloker Daniel E · Owasso, OKBuilt 1994 · S/N E-2885 N3196VOpenshaw Charles M · Huggins, MOBuilt 1947 · S/N D-632 N3196WTs Aviation LLC · Sioux Falls, SDBuilt 1999 · S/N TH-1913 N3197MBonanza Five Flying Club Inc · Roswell, GABuilt 1994 · S/N E-2887 N3198LKatsahnias George T · Denton, TXBuilt 1994 · S/N E-2898 N3199GDriftless Aviation LLC · Wilmington, DEBuilt 1994 · S/N E-2890 N3199HHills Holding · Newark, DEBuilt 1994 · S/N E-2891 N3199JSietsma Lawrence F · Indialantic, FLBuilt 1999 · S/N TH-1899 N319CFOcean Drive Bulgaria Corp · Wilmington, DEBuilt 2001 · S/N 319 N319EEReveille Aviation LLC · Kurten, TXBuilt 2004 · S/N FL-401 N319JDHollingsworth Intergalactic LLC · Clinton, TNBuilt 1997 · S/N 5250216 N319MBAircraft Holding Solutions LLC Trustee · Newark, DES/N LJ-1126 N319TATextron Aviation Inc · Wichita, KSS/N 208B5984 N31CLg & Gs Holdings LLC · Middletown, DES/N 421C0096 N31CJ212 Investments Of Montana LLC · Collinsville, OKBuilt 2001 · S/N 525-0474 N31CULovaas Jean H Trustee · Crescent City, CABuilt 1977 · S/N 421C0341 N31CVN31cv LLC · Thompsons, TXBuilt 1996 · S/N 560-0351 N31FMKing Air Adventure LLC · Wilmington, DEBuilt 1981 · S/N BB-869 N31HAHampden Aviation Services Inc · Florence, MABuilt 2014 · S/N 525-0829 N31HDHotel Delta LLC · Sacramento, CABuilt 1998 · S/N 525-0261

Back to AD 2006-16-18 R1