Skip to content

Registered aircraft · 40,474

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.

N1335PRiggin Flight Service Inc · Madison, SDS/N 23-380 N1335RHughes Michael · Harvard, MABuilt 1975 · S/N AA5-0735 N13362Edwards Samuel T · Mustang, OKBuilt 1976 · S/N 17702415 N13364Cornerstone Aircraft Sales Inc · Wonder Lake, ILBuilt 1973 · S/N 17262702 N13365Pacific Flight Academy LLC · Honolulu, HIBuilt 1973 · S/N 17262703 N13367Hartline Alan G · Benton Harbor, MIBuilt 1973 · S/N 17262705 N1336RManus Phillip P · Tucson, AZS/N AA5-0736 N1336UA & F Aviation Services LLC · Collierville, TNBuilt 1976 · S/N 17267021 N13370Ratcliff Gregory W · Delaware, OHBuilt 1973 · S/N 17262707 N13373Voyagers Flying Club · Akron, OHBuilt 1973 · S/N 17262709 N13376Beahan Timothy Steven · Tampa, FLFirst renewal noticeBuilt 1973 · S/N 17262712 N13377Dean Aaron · Bella Vista, CABuilt 1973 · S/N 17262713 N13378Hare Jeffrey P · Cornelius, NCBuilt 1973 · S/N 17262714 N13379Gittleson Vernon H · Franklin Grove, ILBuilt 1976 · S/N 17702416 N1337RZimmerman Christopher Paul · Canandaigua, NYBuilt 1975 · S/N AA5-0737 N1337TTrate Ava · Selbyville, DEBuilt 1972 · S/N 28-7225394 N13383Alpha Aviation-1 LLC · Naples, FLBuilt 1973 · S/N 17262718 N13384Premier Vacations LLC · Haines City, FLBuilt 1973 · S/N 17262719 N13386Crosswind Aviation Of Oklahoma LLC · Stillwater, OKS/N 17262720 N13391Brazos Valley Flight Services LLC · College Station, TXBuilt 1973 · S/N 17262723 N13394Ck Leasing Services LLC · Wilmington, DEBuilt 1973 · S/N 17262725 N13399Great Plains Spraying Inc · Colby, KSBuilt 1973 · S/N 17262729 N1339CWalt'S Kustom Kreations Inc · Palatka, FLBuilt 1953 · S/N 22-1135 N1339RWilcox Marion L Trustee · La Mesa, CABuilt 1975 · S/N AA5-0739 N133AJAmerican Patrols Inc · Midland, TXBuilt 1986 · S/N 17276614 N133DWFann Rentals LLC · Gillette, WYBuilt 1997 · S/N 22012 N133FKing Tyler B · Saint Stephen, SCBuilt 1956 · S/N 22-4023 N133JLAlpha Air Inc · Wrightwood, CABuilt 2002 · S/N JF22773 N133SFNelson Dennis E · Jamestown, NDBuilt 1966 · S/N 28-22323 N13400Opolka John G · Midlothian, TXBuilt 1973 · S/N 17262730 N13402Cartwright Edward N · Winterville, NCBuilt 1973 · S/N 17262731 N13404Kroner David S · Rock Creek, OHBuilt 1973 · S/N 17262733 N13405Kelley Aircraft LLC · Weyers Cave, VABuilt 1973 · S/N 17262734 N13406Shore Stephen A · Thurmond, NCS/N 17262735 N1340TMaw Enterprises USA LLC · Hudson, FLBuilt 1972 · S/N 28-7225470 N13411Leiss Todd J · Merritt Island, FLBuilt 1976 · S/N 17702419 N1341RTmp Aviation LLC · Altamonte Springs, FLBuilt 1975 · S/N AA5-0741 N13426Sardeson Ronald L · Greenwood, NEBuilt 1973 · S/N 17262744 N13429Mercado Carlos · San Juan, PRBuilt 1973 · S/N 17262746 N1342HRobertson James P Trustee · Templeton, CABuilt 1977 · S/N 28-7790307 N1342RGladden Thomas E · Otis Orchards, WABuilt 1975 · S/N AA5-0742 N1342UBell Scott A · Mc Alpin, FLS/N 4 N1343Clark Curtis E · Scottsdale, AZBuilt 1967 · S/N 1 N13430Mjr Assoc LLC · Bend, ORBuilt 1976 · S/N 17702420 N13431Kelly William W · Springfield, ORBuilt 1973 · S/N 17262748 N13435Torres Debra A · El Paso, TXBuilt 1973 · S/N 17262749 N13437Dyberg Michael DBA · Mount Vernon, WABuilt 1973 · S/N 17262751 N1343WInfinity Aviation LLC · Piedmont, SDBuilt 1964 · S/N 2693 N13445Laurel Highlands Aeronautical Academy · Latrobe, PABuilt 1973 · S/N 17262756 N13447Vessichelli Ryan A · Virginia Beach, VABuilt 1973 · S/N 17262757

Back to AD 80-04-03 R2