Skip to content

Registered aircraft · 8,920

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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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.

N1107CSale Reported · Rigby, IDSale reportedBuilt 1953 · S/N 22-953 N110FBurke Nicholas S · Eagle River, AKBuilt 1952 · S/N 22-888 N110LFComanche Flyer Foundation Inc · Blaine, WAS/N 24-695 N110LLFlight Level 7 Inc · Wilmington, DEBuilt 1971 · S/N 39-89 N110WWTorba Jacob · Citrus Heights, CABuilt 1969 · S/N 30-1846 N1111HBielamowicz John Kolbe · Waxahachie, TXBuilt 1964 · S/N 30-427 N11151Kowest Aviation LLC · Enid, OKBuilt 1959 · S/N 24-1631 N1116PSale Reported · Scottsville, VASale reportedBuilt 1955 · S/N 23-126 N111DLCresence LLC · Port Saint Lucie, FLBuilt 1976 · S/N 27-7654167 N111EWimpy Scott · Griffin, GAS/N 24-4210 N111LFZimmerman Leland · Center, COBuilt 1959 · S/N 24-1023 N111MYMeshed Networx LLC · New Market, VABuilt 1978 · S/N 27-7854092 N111PLColumbia Asset Trust Corp Trustee · Wichita, KSBuilt 1969 · S/N 301929 N111SEKeith Fischer · Gig Harbor, WABuilt 1966 · S/N 24-4462 N111SLKaehlert Lottie DBA · Rifle, COS/N 24-2532 N1123CTuschhoff Stetson Rd · Jackson, MOBuilt 1953 · S/N 22-960 N1123PRegistration Pending · Flint Hill, VARegistration pendingS/N 23-133 N1124CBukowski Bruno · Phoenix, AZBuilt 1953 · S/N 22-966 N1125CCrosta Michael A · Sugar Grove, ILBuilt 1953 · S/N 20-958 N112WSEdgeington Randall K · Riverton, WYBuilt 1961 · S/N 24-2765 N1130CLaw David L · Derby, KSBuilt 1953 · S/N 22-965 N1131PDBA Congdons Aviation Service · Anchorage, AKS/N 23-141 N1132CWinaught Michael A · Louisville, TNBuilt 1953 · S/N 22-969 N1132PR & S Stuart Co Inc · Wilmington, DEBuilt 1955 · S/N 23-142 N1134PSutton Aircraft Salvage LLC · Palmer, AKBuilt 1955 · S/N 23-146 N1136CCarruthers Steven L · Livingston, TNBuilt 1953 · S/N 22-972 N113JBMcdonald Aviation Inc · Knoxville, TNBuilt 1960 · S/N 27-226 N1140CAtkins Alvin R · Barnstead, NHBuilt 1953 · S/N 22-973 N1140PCromley Amanda J · Lewisburg, PABuilt 1955 · S/N 23-152 N1147N7371y LLC · Waterford, MIBuilt 1964 · S/N 30-423 N114CDNorwest Ventures LLC · Santa Cruz, CABuilt 1963 · S/N 30-37 N114NXin Han Aviation LLC · Atwater, CABuilt 1979 · S/N 44-7995289 N114RSLuggelle Michael · Hull, MABuilt 1966 · S/N 30-1094 N114XTaft Plumbing Co Inc · Taft, CABuilt 1961 · S/N 24-2698 N1158PLorenzo Walker Institute Of Tech · Naples, FLBuilt 1955 · S/N 23-171 N115JDC R Aviation Inc · Miami, FLS/N 27-7405395 N1164CWilliams Allen J · Greybull, WYBuilt 1953 · S/N 22-989 N1166CAmaya Leonardo H · Port Lavaca, TXBuilt 1953 · S/N 22-990 N1166PDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1955 · S/N 23-180 N1167CMountain Bluebird Aviation LLC · Kalispell, MTBuilt 1953 · S/N 22-992 N1167PCascadia Air Ventures Inc · Winlock, WABuilt 1955 · S/N 23-181 N1168CPartridge James R · Chino Valley, AZBuilt 1953 · S/N 22-994 N116MFWeber Donald E · Saint David, AZS/N 27-3522 N1171CUnser Joshua D · Anchorage, AKBuilt 1953 · S/N 20-963 N1172PSteed William B · Winnsboro, SCS/N 23-175 N1174PHardin John M · Terrell, TXBuilt 1955 · S/N 23-188 N1188YSkylark Flight Training LLC · Panama City, FLBuilt 1964 · S/N 30-403 N1189PParks Eric · Matthews, NCBuilt 1955 · S/N 23-203 N118ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2000 · S/N 4496034 N118BLEdge Aviation LLC · Hawthorne, FLBuilt 1965 · S/N 30-913

Back to AD 85-02-05 R1