Skip to content

Registered aircraft · 40,472

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

N406TWT C Willis LLC · Three Forks, MTS/N 1217 N40704Dikun Paul M · Bensalem, PABuilt 1973 · S/N 28-7425147 N4070ZN333bc LLC · Franktown, COS/N 18-8081 N40718Datchair LLC · Chattanooga, TNBuilt 1973 · S/N 28-7425150 N4071ELegends Airways LLC · Lakeland, FLBuilt 1977 · S/N 18-7809061 N4072ZEsparza Phillip G · Cresson, TXBuilt 1991 · S/N 1884 N40735Magsig Joel S · Huntsville, ALBuilt 1973 · S/N 28-7425152 N4073EBenjamin Vince Lewis · Seward, AKBuilt 1977 · S/N 18-7809051 N4073NBoswinkel Aviation Inc · Wilmington, DEBuilt 1968 · S/N 680031 N4073XWakenigg Michael C · Madison, GABuilt 1970 · S/N 5173 N40740Veit John · Port Jefferson, NYBuilt 1973 · S/N 28-7405062 N4074THillsboro Aero Academy LLC · Hillsboro, ORBuilt 1991 · S/N 1787 N4074VRowberry Spencer · Grantsville, UTBuilt 1995 · S/N 1 N4074XSmith Byron L · Payette, IDBuilt 1970 · S/N 5174 N40752Jourdan Frank E · Overland Park, KSBuilt 1973 · S/N 28-7425155 N4075PHolder Jeffrey J · Madison, GABuilt 1958 · S/N 23-1537 N4075TCms Land Co · Richmond, TXBuilt 1952 · S/N 18-1857 N40767Bart Steven C · Highland, CABuilt 1973 · S/N 28-7405064 N4076HSummerskyz Inc · Saint Joseph, ILBuilt 1991 · S/N 1799 N4076XAllen Kent E · Jacksonville, ILBuilt 1971 · S/N 5176 N40776Third Coast Aircraft LLC · Mobile, ALBuilt 1973 · S/N 28-7425163 N4077ZN4077z LLC · Wasilla, AKBuilt 1964 · S/N 18-8091 N40787Henrich Perrin · Northridge, CABuilt 1973 · S/N 28-7425164 N4078PHawaii Pacific Aviation Inc · Kailua Kona, HIBuilt 1991 · S/N 1806 N4078XEspey Brendan L · Sandy Springs, GABuilt 1970 · S/N 5178 N40798Hovnanyan Ari · Woodland Hills, CABuilt 1973 · S/N 28-7415087 N4079XRichardson Scott · Grapevine, TXBuilt 1970 · S/N 5179 N4079ZNewton James K · Charles Town, WVBuilt 1963 · S/N 18-8093 N407FTSlipstream Inc · Cincinnati, OHBuilt 1982 · S/N 28-8216216 N407MNMaldonado Leopoldo · Paramount, CABuilt 1983 · S/N 407 N407SGriffing Flying Service Inc · Port Clinton, OHBuilt 1979 · S/N 28-7990545 N407WBBad Dog Aviation LLC · Wasilla, AKBuilt 1963 · S/N 18-8085 N40806Sky Dream Flight School LLC · Dallas, GABuilt 1973 · S/N 28-7425169 N4080ZVan Dyke Brian S · Rio Oso, CABuilt 1964 · S/N 18-8094 N40810Qualitair LLC Trustee · MichelstadtBuilt 1973 · S/N 28-7415088 N40812Dae Aviation Enterprises Corp · Gilford, NHBuilt 1973 · S/N 28-7405068 N4081EOrlando Aircraft Sales LLC · Orlando, FLBuilt 1991 · S/N 1916 N40823Ashley Aviatrix LLC · Atlanta, GABuilt 1973 · S/N 28-7425173 N40829Shively Ray F · Turtlepoint, PABuilt 1973 · S/N 28-7415090 N4082JEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1991 · S/N 1794 N4082XLeach Joey D · Flat Rock, INBuilt 1971 · S/N 5182 N40830Spirit Of Rocky Mount LLC · Nashville, NCFirst renewal noticeBuilt 1973 · S/N 28-7415091 N40836Hawkins Joshua L · Colbert, GABuilt 1973 · S/N 28-7425176 N40838Andrews Mark F · Jacksonville, FLBuilt 1973 · S/N 28-7415093 N4083EHulsey Steven M · Chugiak, AKBuilt 1977 · S/N 18-7809056 N4083XKnutson Wayne R · Thompson, NDBuilt 1971 · S/N 5183 N4083ZRaymond Raphael T · Helix, ORBuilt 1964 · S/N 18-8098 N40842Avz Aviation Inc · Knoxville, TNBuilt 1973 · S/N 28-7415094 N40845Rich Lucas Aircraft Sales LLC · Lincoln Park, NJBuilt 1973 · S/N 28-7405070 N4084EIngham Ben B · Sonora, TXS/N 18-7809058

Back to AD 80-04-03 R2