Skip to content

Registered aircraft · 54,017

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.

N4502UWise Joseph D · Kilgore, TXBuilt 1964 · S/N 15060502 N45031Stahla Russell · Girdwood, AKBuilt 1975 · S/N 15076709 N45034Coffelt Roy · Nampa, IDBuilt 1975 · S/N 15076710 N45045Lingle Gordon D · Gun Barrel City, TXBuilt 1975 · S/N 15076711 N4504CHickle William H · Inyokern, CABuilt 1952 · S/N 25448 N4504NHayton James B · Sedro Woolley, WAS/N 18502550 N45058Red Cardinal Aviation LLC · Chantilly, VAS/N 15076715 N4505UYates Kenneth E · Meridian, MSBuilt 1964 · S/N 15060505 N45060Stone Eric · Cedarpines Park, CABuilt 1976 · S/N 177RG1091 N4506CIliamna Copper River Fly Fishing Lodge LLC · Livingston, MTBuilt 1974 · S/N 18502576 N4506UBryson James D · Casstown, OHBuilt 1964 · S/N 15060506 N45073Trailing Edge LLC · Elmira, NYBuilt 1975 · S/N 15076724 N4507FRodriguez Kenneth C · East Wenatchee, WABuilt 1966 · S/N 185-0989 N45080Todd Doug A · Dewitt, IABuilt 1975 · S/N 15076726 N45082Long Robert D · Kinston, NCBuilt 1975 · S/N 15076727 N45086Dahl Ken L · Granite Falls, MNBuilt 1976 · S/N 177RG1092 N4508FStotz Jon · Rockford, MIBuilt 1966 · S/N 185-0990 N4509BTrompeter Mark S · Intl Falls, MNBuilt 1955 · S/N 31408 N4509CReams Thomas M · Panacea, FLBuilt 1952 · S/N 25453 N4509JHill Curtis E · Bancroft, IDBuilt 1981 · S/N T18803741T N450CSCbcb Aircraft LLC · Colfax, WABuilt 1979 · S/N P21000214 N450DHHewitt Rod · Federal Way, WAS/N 21057998 N450JTN450jt LLC · Colleyville, TXBuilt 1981 · S/N 18268032 N450RETurrell James A · Flagstaff, AZBuilt 1953 · S/N 7586 N450SCSky West Aviation Inc Trustee · Albuquerque, NMS/N P2100294 N450SEAok LLC · Omaha, NES/N P21000605 N4510CAyres Vance · Harrison, ARBuilt 1952 · S/N 25454 N4510UOrsak Chris L · Seymour, TXBuilt 1964 · S/N 15060510 N45112Iaba LLC · Norfolk, VABuilt 1975 · S/N 15076739 N45115Jiang Jun · Fremont, CAS/N 15076740 N4511EN2893e LLC · Reno, NVBuilt 1978 · S/N 17271619 N45128Bowker James K · Ponca City, OKBuilt 1976 · S/N 177RG1093 N45132Jamesweathers Robi J · Blaine, MNS/N 15076747 N4513BBishop Robert W · Celina, TXBuilt 1955 · S/N 31412 N4513CSlowpoke Air LLC · Palm Harbor, FLS/N 25457 N45143Fly Sky Ads LLC · Manalapan, NJBuilt 1975 · S/N 15076753 N45156Flight Training Solutions LLC · Longwood, FLBuilt 1975 · S/N 15076760 N4515BWestern Parachute Sales Inc · Eagle Creek, ORBuilt 1955 · S/N 31414 N45166Jet Life LLC · Coconut Creek, FLS/N 15076764 N45169Carlisle Elizabeth L · Mohnton, PABuilt 1975 · S/N 15076766 N4516CStahlman Michael J · Portland, ORBuilt 1952 · S/N 25460 N4516USteelman Aviation LLC · Montague, CAS/N 15060516 N45170Smits Joel R · Crete, ILBuilt 1975 · S/N 15076767 N4517B4517b Holding Group LLC · Moses Lake, WAS/N 31416 N4517CHainline Thomas D · Sumter, SCBuilt 1952 · S/N 25461 N4517FAeropod Inc · Aurora, COS/N 185-1001 N45188Arias Armando D · Santa Cruz, CABuilt 1976 · S/N 177RG1095 N4518CLongden Earl W · Spirit Lake, IDBuilt 1954 · S/N 25462 N45190Violette Colin E · Rough And Ready, CABuilt 1975 · S/N 15076777 N45193Bostwick James · Melrose, NMBuilt 1976 · S/N 177RG1096

Back to AD 87-20-03 R2