Skip to content

Registered aircraft · 54,015

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:87-20-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:87-20-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:87-20-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:87-20-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:87-20-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:87-20-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.

N63VTFlyways LLC · Bemidji, MNBuilt 1969 · S/N 18259760 N63WSCooks Saw Manufacturing LLC · Newton, ALBuilt 1964 · S/N 21058333 N63XYRegistered aircraftS/N 31651 N64001Alpha One Aviation LLC · Corona, NYBuilt 1975 · S/N 17264949 N64007Baugh Tommye R · Star City, ARBuilt 1975 · S/N 17264955 N6400BHowes Frank E · Macomb, MIBuilt 1956 · S/N 29600 N6400FAirplanes Unlimited LLC · Jackson, TNBuilt 1966 · S/N 15063000 N6400GCollier James S · Jesup, GABuilt 1970 · S/N 15071900 N6400QHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1981 · S/N 15285244 N6400VFearon Kenneth M · Sidney, OHBuilt 1980 · S/N 172RG0662 N64012Jin Jin Aviation LLC · Anchorage, AKBuilt 1981 · S/N 17275505 N64014Maynor Robert B · Mansfield, LABuilt 1975 · S/N 17264961 N64016Ponderosa Aviators LLC · Baker, MTBuilt 1975 · S/N 17264963 N64017Pilots Today Inc · Berlin, MDBuilt 1975 · S/N 17264964 N6401EReynolds Richard E · Trumansburg, NYBuilt 1959 · S/N 46501 N6401FPfd Aviation LLC · Sheridan, WYBuilt 1966 · S/N 15063001 N6401VGdl Aviation LLC · Lincoln, NEBuilt 1980 · S/N 172RG0663 N64020Bend Aircraft Mechanics LLC · Bend, ORBuilt 1975 · S/N 17264966 N64023Rawson Aviation LLC · Collinsville, OKBuilt 1975 · S/N 17264969 N64027Snyder Brent R · Dallas, TXBuilt 1985 · S/N R18202021 N6402EWichman Scott A · Lewistown, MTS/N 46502 N6402FMaier Andrew J · Barnesville, MNBuilt 1965 · S/N 15063002 N6402NManos Con Alas Aviation · Stateline, NVBuilt 1978 · S/N 21062978 N6402VG&M Aircraft Inc · Wheat Ridge, COBuilt 1980 · S/N 172RG0664 N64034State Of Louisiana · Baton Rouge, LABuilt 1981 · S/N 17275507 N64035Loomis Darwin · Mooreland, OKBuilt 1975 · S/N 17264980 N6403EGultch Dale R · Brookfield, WIBuilt 1959 · S/N 46503 N6403FFertile Flying Club Inc · Fertile, MNBuilt 1966 · S/N 15063003 N6403GKassel Willard C · Sicily Island, LAS/N 15071903 N6403MPlane N Simple Aviation LLC · Los Angeles, CABuilt 1980 · S/N 15284711 N6403VVista Aviation Inc · Pacoima, CABuilt 1980 · S/N 172RG0665 N64040Golding Donald J · Tucson, AZBuilt 1981 · S/N 17275509 N64043Aira Aviation LLC · Grand Ledge, MIFirst renewal noticeBuilt 1975 · S/N 17264981 N64044Johnson Lance D · Duluth, MNS/N 18052865 N64045Walker Robert · Chula Vista, CABuilt 1975 · S/N 17264983 N64046Biesecker Michael Gary · High Point, NCBuilt 1975 · S/N 17264984 N64048Gray Peter A · Salinas, CABuilt 1975 · S/N 17264986 N6404FHigh Demand Earthworks & Vineyard Development LLC · Napa, CABuilt 1975 · S/N 18264190 N6404GWarrior Aviation LLC · Prior Lake, MNBuilt 1970 · S/N 15071904 N64053Collins Thomas A · Orleans, MABuilt 1975 · S/N 17264990 N64056Angel Aviation Inc · Peoria, AZBuilt 1981 · S/N 17275512 N6405ERiggs Bradley A · Emporia, KSBuilt 1959 · S/N 46505 N6405GArmond Richard J · Thousand Oaks, CABuilt 1970 · S/N 15071905 N6405XArctic Aviation Leasing LLC · Anchorage, AKBuilt 1980 · S/N U20605870 N64061Stark Glenn M · Nampa, IDBuilt 1975 · S/N 17264994 N64062M G Enterprises Of Albert Lea Inc · Alden, MNBuilt 1975 · S/N 17264995 N64063Bowers Alan B · Bellevue, WABuilt 1975 · S/N 17264996 N64065Lg Holdings LLC · Gretna, NES/N 17275514 N64067Duvall Chris D · Tahlequah, OKBuilt 1975 · S/N 17264998 N64069Whiskey Tango Aviation LLC · Keene, NDBuilt 1981 · S/N 17275515

Back to AD 87-20-03 R2