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.

N61301Southern Seaplane Inc · Belle Chasse, LABuilt 1980 · S/N 18504144 N6130BFandango Aviation LLC · Lake Elsinore, CABuilt 1956 · S/N 34130 N6130CMay And Carter Oil Co · Jackson, GABuilt 1979 · S/N 21063808 N6130DJones Matthew A · Saluda, NCBuilt 1979 · S/N 17272610 N6130ERounds Donald W DBA · Waller, TXS/N 46230 N6130FBas Part Sales LLC · Greeley, COBuilt 1968 · S/N 21059030 N6130MKing Mike · Webster, TXFirst renewal noticeBuilt 1980 · S/N 15284627 N6130RHarris Phillip S · Greenwood Village, COS/N T210-0030 N61311Wood James A · Madera, CABuilt 1969 · S/N 15070955 N6131AWigen Mary E · Porthill, IDBuilt 1979 · S/N 21063508 N6131EWilliams Rick J · Cooperstown, NYBuilt 1958 · S/N 46231 N6131FLundell Brandon M · Lyons, COBuilt 1968 · S/N 21059031 N6131GCragg Gordon E · Georgetown, TXBuilt 1969 · S/N 15071631 N6131RAir LLC · Salem, ORS/N T210-0031 N61321Gerdes Brian K · Los Alamitos, CAS/N 15070963 N61323N61323 LLC · Portland, ORBuilt 1980 · S/N 18504147 N61324Wills Evan J · Lynnwood, WABuilt 1969 · S/N 15070964 N61325Zetir Mohamad · Oviedo, FLBuilt 1969 · S/N 15070965 N61329Girls Love To Fly Inc · Roseville, CABuilt 1969 · S/N 15070969 N6132GMorcom Aviation Services Inc · Everett, WABuilt 1979 · S/N 17273570 N6132QHeavy Metal Air LLC · Farmingdale, NYS/N 15285156 N6132VDorsey Russell R · Phoenix, AZBuilt 1980 · S/N 172RG0584 N61333Gustafson Michael J · Minnetonka, MNBuilt 1969 · S/N 15070972 N61336Evans David C · Thousand Oaks, CABuilt 1969 · S/N 15070973 N61338Flyit LLC · Camas, WABuilt 1969 · S/N 15070975 N6133DThomas Aviation · Granada Hills, CABuilt 1979 · S/N 17272611 N6133GRosebud Aviation · Gregory, SDBuilt 1973 · S/N 18801176 N6133KSturguess James K · Boonville, MOS/N 15077542 N61345Carlson Brent A · Shelley, IDS/N 15070980 N6134ECf Ranch & Cattle Co LLC · Burbank, OHBuilt 1981 · S/N P21000737 N6134GMagruder David · Independence, LABuilt 1979 · S/N 17273571 N6134KMackenzie Stuart · Pearland, TXS/N 15077543 N6134LEuro 2000 Inc · Merritt Island, FLS/N 15284362 N61354New Vision Aviation · Fresno, CABuilt 1969 · S/N 15070985 N6135EAce Aviation LLC · Mankato, MNBuilt 1980 · S/N 18504003 N6135FJr Imaging Logistics Inc · Pasco, WABuilt 1973 · S/N A1500423 N6135QLake Effect Aviation LLC · Java Center, NYBuilt 1981 · S/N 15285159 N6135RStafford Michael J · Clovis, CABuilt 1979 · S/N 172RG0089 N61363Hulbert Stephen R · Fort Ransom, NDBuilt 1969 · S/N 15070989 N61365Plane Progress LLC · Waterloo, IABuilt 1969 · S/N 15070990 N61368Department Of Inland Fisheries And Wildlife · Augusta, MEBuilt 1980 · S/N 18504159 N6136ERotormate LLC · Royse City, TXS/N 46236 N6137EPennington Mitchell T · Medley, WVBuilt 1978 · S/N 17271994 N6137FWingland Inc · Los Angeles, CABuilt 1968 · S/N 21059037 N6137GPiersol Benjamin T · Honey Brook, PABuilt 1969 · S/N 15071637 N6137TDurnin Timothy K · Lansing, ILS/N R18201917 N61387Stash Ventures LLC · Virginia Beach, VABuilt 1980 · S/N 18504168 N61388Seidler Matthew J · Anchorage, AKBuilt 1980 · S/N 18504169 N6138FSchlegelmilch Scott A · Elkhorn, NEBuilt 1968 · S/N 21059038 N6138GStrange Keith · Lincoln, MEBuilt 1969 · S/N 15071638

Back to AD 87-20-03 R2