Skip to content

Registered aircraft · 25,369

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-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.

N7304TGalaxy Aviation LLC · Nantucket, MAS/N R18200027 N73054Blue Wings LLC · Spokane, WABuilt 1976 · S/N 17267253 N7305LHill Stephen C · Fort Collins, COBuilt 1978 · S/N A1520780 N73063Oregon State Flying Club · Corvallis, ORBuilt 1976 · S/N 17267256 N73064Whitelam Bruce R · Sacramento, CABuilt 1976 · S/N 17267257 N73068Christensen Gary D · Alliance, NEFirst renewal noticeBuilt 1976 · S/N 17267259 N73069Eagle Sky Patrol Inc · Deadwood, SDBuilt 1976 · S/N 17267260 N7306EG & M Aircraft Inc · Wheat Ridge, COBuilt 1978 · S/N 17272081 N7306X06x-Ray LLC · El Paso, TXBuilt 1977 · S/N R18200069 N7308GOrlandi Properties LLC · Blairstown, NJBuilt 1970 · S/N 17259008 N73091Rudder33 LLC · Grantham, NHBuilt 1976 · S/N 17267261 N73093Yngsdal Dale A · Lino Lakes, MNBuilt 1976 · S/N 17267262 N730ACHeimbach Paul A · Steamboat Springs, COBuilt 1999 · S/N 1277-99 N730ETWolfgram Patrick Michael · Ham Lake, MNS/N 3226 N730HAHonaker Group LLC · Sellersburg, INS/N 17267246 N730LBEarly Bird Aviation LLC · Rillito, AZBuilt 1974 · S/N 17263162 N73103Bfl Aviation LLC · Bakersfield, CABuilt 1976 · S/N 17267267 N73105Jlk Management LLC · Kerrville, TXBuilt 1976 · S/N 17267268 N7310GMccall Freddie W Jr · East Brewton, ALBuilt 1970 · S/N 17259010 N73113Top Flight Aviation Inc · Corona, CABuilt 1976 · S/N 17267269 N73116Taildraggers Flyers Inc · Saint Joseph, MIBuilt 1976 · S/N 17267272 N7311SDayton Pilots Club Inc · Germantown, OHBuilt 1981 · S/N R18201703 N7312WRegistered aircraftBuilt 1977 · S/N R18200053 N7312XFellows Thomas C · Prescott, AZBuilt 1977 · S/N R18200071 N73131Fremont Flight Academy LLC · Fremont, OHBuilt 1976 · S/N 17267280 N73134Harborside Aviation Services Inc · Punta Gorda, FLBuilt 1976 · S/N 17267281 N73146Oregon State Flying Club Inc · Corvallis, ORBuilt 1976 · S/N 17267287 N73148Kinney Transportation · Columbia, MOBuilt 1976 · S/N 17267289 N73149Good Flight Aviation LLC · Stockton, CABuilt 1976 · S/N 17267290 N7314GKittle Aviation LLC · Wichita, KSBuilt 1970 · S/N 17259014 N73151Hawaii Aviators LLC · Ewa Beach, HIBuilt 1976 · S/N 17267292 N73154Bishop Services LLC · Ellisville, MSBuilt 1976 · S/N 17267293 N7316GCox Capital LLC · Rushville, MOS/N 17259016 N73170Jahawk Leasing LLC · Sugar Grove, ILBuilt 1976 · S/N 17267297 N73171Jettmar Rainer U · Washington, DCBuilt 1976 · S/N 17267298 N73172American Patrols Inc · Midland, TXBuilt 1976 · S/N 17267299 N73174Welch Cleatus E · Orlando, FLBuilt 1976 · S/N 17267301 N73178G P Holding Inc · Mora, MNBuilt 1976 · S/N 17267305 N73179Weengknutts 179 · Delta, UTS/N 17267306 N7317GSettles Lauren E · Owensboro, KYBuilt 1970 · S/N 17259017 N7317XMoore Samuel B · Tucson, AZS/N R18200073 N73181Nurse Alex S · San Diego, CABuilt 1976 · S/N 17267308 N73183Sandwich Aviation Inc · Somonauk, ILBuilt 1976 · S/N 17267310 N73189Ellie Air LLC · Mabank, TXBuilt 1976 · S/N 17267316 N7318GMay Curtis · Joplin, MTBuilt 1970 · S/N 17259018 N73190Flying J Enterprises LLC · San Antonio, TXBuilt 1976 · S/N 17267317 N73192Nationwide Aviation LLC · Hudson Oaks, TXBuilt 1976 · S/N 17267319 N73195Saratoga Flyers Inc · South Glens Falls, NYBuilt 1976 · S/N 17267322 N73197Seward Kent · Parma, IDBuilt 1976 · S/N 17267324 N73198Davis Jimmy R Jr · Wharton, TXBuilt 1976 · S/N 17267325

Back to AD 80-25-07 R1