Skip to content

Registered aircraft · 657

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:91-25-08-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:91-25-08-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:91-25-08-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:91-25-08-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:91-25-08-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:91-25-08-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.

N421WEInternational Air Services Inc Trustee · Carson City, NVS/N 421C0024 N421WKKb Air LLC · Bakersfield, CABuilt 1981 · S/N 421C1230 N421WNContractors Flight Service LLC · La Jolla, CABuilt 1976 · S/N 421C0100 N421WPMach 1 LLC · Rogers, ARS/N 421C0417 N421WSGandy John B · Conroe, TXBuilt 1977 · S/N 421C0433 N421WTWest One Holdings Inc · Cheyenne, WYBuilt 1978 · S/N 421C0620 N421XLLocaero Services Inc Trustee · Wilmington, DEBuilt 1979 · S/N 421C0803 N421XTAdam & Anya Holdings LLC · Wichita, KSBuilt 1978 · S/N 421C0447 N421XXLong William David · San Antonio, TXBuilt 1976 · S/N 421C0238 N421YBBotsis Aircraft Limited Inc · Chesterland, OHS/N 421C1212 N421YWTrl Aviation LLC · Little Rock, ARBuilt 1984 · S/N 421C1402 N421YYVsa Leasing LLC · Linden, MIBuilt 1980 · S/N 421C0872 N421ZM3tr Aviation LLC · Longview, TXBuilt 1981 · S/N 421C1058 N421ZXBurmingham Don Trustee · Duarte, CAS/N 421C0304 N421ZZ421zz LLC · Wilmington, DES/N 421C1220 N422CMAerostar Aviation LLC · Tucson, AZBuilt 1981 · S/N 421C1046 N422DBurton Rick · Vancouver, WABuilt 1982 · S/N 421C1202 N422GMMidocin LLC · Southfield, MIBuilt 1976 · S/N 421C0055 N422PJCra Aviation LLC · Dickerson, MDBuilt 1981 · S/N 421C-1038 N423TMJp Aviation Leasing LLC · Salt Lake City, UTBuilt 1976 · S/N 421C-0107 N424JAJzj Air LLC · Wilmer, ALS/N 421C0885 N425ADJuno Farm LLC · Middleburg, VABuilt 1981 · S/N 425-0141 N425ALSpyder Luke LLC · Tucson, AZS/N 425-0100 N425AR5937 Ventures LLC · Rockford, ILS/N 425-0065 N425BAMarchetti 211 LLC · Alva, OKS/N 4250046 N425BLBrannan Susan · New Braunfels, TXBuilt 1984 · S/N 425-0198 N425BMPlane Fun Inc Tr Trustee · Snellville, GABuilt 1984 · S/N 4250190 N425BSSpur Aviation LLC · Laredo, TXS/N 425-0210 N425CC11:11 Enterprises LLC · San German, PRBuilt 1982 · S/N 425-0159 N425CFTracking Lines LLC · Las Vegas, NVBuilt 1983 · S/N 4250131 N425CQHeritage On Lanier Inc · Gainesville, GABuilt 1983 · S/N 425-0173 N425DUnited Industries LLC · Scottsdale, AZBuilt 1981 · S/N 425-0121 N425DCLola Air LLC · Reno, NVBuilt 1983 · S/N 425-0185 N425DDAir Flair Inc · Maurice, IABuilt 1981 · S/N 425-0083 N425DHElectronic Concepts Inc · Eatontown, NJBuilt 1981 · S/N 425-0066 N425DKDtt Holdings LLC · Kalispell, MTBuilt 1981 · S/N 425-0086 N425DRAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1984 · S/N 4250199 N425DVVerner David W · Mcalester, OKBuilt 1985 · S/N 425-0232 N425EQueen Bee Air Specialties Inc · Rigby, IDBuilt 1981 · S/N 425-0096 N425EMVfr Air LLC · Tifton, GABuilt 1982 · S/N 425-0164 N425ETTexas Eco Services Inc · Fort Worth, TXBuilt 1981 · S/N 425-0072 N425EZBilbo Foster Holdings LLC · Lubbock, TXS/N 425-0099 N425FSkyfarm LLC · La Jolla, CAS/N 425-0058 N425FZN425fz Corp Trustee · Wilmington, DEBuilt 1981 · S/N 425-0059 N425GCResiak LLC · Middleton, WIBuilt 1981 · S/N 425-0027 N425HBBank Of Utah Trustee · Salt Lake City, UTBuilt 1981 · S/N 425-0073 N425HDDodson International Parts Inc · Rantoul, KSBuilt 1981 · S/N 425-0113 N425HJApd Development LLC · Palatine, ILBuilt 1984 · S/N 425-0169 N425JBCentral Aviation LLC · Sebring, FLBuilt 1981 · S/N 425-0043 N425JESaturn International LLC · Cheyenne, WYBuilt 1981 · S/N 4250008

Back to AD 91-25-08 R1