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.

N58457Registered aircraftBuilt 1973 · S/N 18262075 N58458Prairie Wings Aviation LLC · Victoria, TXBuilt 1973 · S/N 18262076 N5845GBerg William J · Aberdeen, SDS/N 15071345 N58465Ram Air LLC · Portland, MEBuilt 1973 · S/N 18262079 N58466Aerial Transport LLC · Dover, DEBuilt 1974 · S/N U20602609 N58467Schaefer Leonard · Oak Dale, PABuilt 1973 · S/N 18262081 N58469Caj Holdings LLC · College Station, TXBuilt 1973 · S/N 18262083 N5846AHalford Richard W · Eagle River, AKBuilt 1956 · S/N 28446 N58470Kraiger Rockne C Trustee · Galesburg, MIBuilt 1973 · S/N 18262084 N58472West Central Construction LLC · Indian Valley, IDBuilt 1973 · S/N 18262086 N5847ACochran Josh · New Orleans, LABuilt 1956 · S/N 28447 N5847BHart Johndale · Pagosa Springs, COS/N 33847 N58483Thaxton James T · Mcminnville, TNBuilt 1973 · S/N 18262093 N58484Centurion Enterprises Inc · Lake Elmo, MNBuilt 1973 · S/N 18262094 N58488Gillies Ken G · Stockton, CABuilt 1973 · S/N 18262097 N5848BOdenbrett Jeffrey E · Brighton, COFirst renewal noticeBuilt 1956 · S/N 33848 N5848GDerby City Aviation LLC · Vero Beach, FLBuilt 1969 · S/N 15071348 N58496Gubran Robert S · Monterey Park, CABuilt 1973 · S/N 18262103 N58498Wooding William W · Anacortes, WABuilt 1973 · S/N 18262104 N5849AAllison Michael L · Lubbock, TXBuilt 1956 · S/N 28449 N5849JFowler Jon E · Hallock, MNBuilt 1970 · S/N 18501818 N584AFAda Forestry Division · Malvern, ARBuilt 1972 · S/N 18261153 N584SFDsr Cherokee 180 LLC · Dallas, TXBuilt 1968 · S/N 17256834 N58502H E Fly Float LLC · Virginia Beach, VABuilt 1974 · S/N U20602618 N58504P S C Flyers · Cardiff By The Sea, CABuilt 1973 · S/N 18262107 N58505Pike Medical Inc · Chillicothe, OHBuilt 1973 · S/N 18262108 N58506Krume Eric R · Castle Rock, WABuilt 1973 · S/N 18262109 N5850F5850f LLC · Monroe Township, NJBuilt 1967 · S/N 21058850 N58515Cowan Michael A · Buckeye, AZBuilt 1973 · S/N 18262115 N58517Walthers Michael L · Portland, ORBuilt 1973 · S/N 18262116 N58518N58518 Flying Club LLC · Vancouver, WABuilt 1973 · S/N 18262117 N5851RSmoky Bear Air LLC · Rockwood, TNBuilt 1965 · S/N 17253520 N58522Ryan Donald E · Fort Payne, ALBuilt 1973 · S/N 18262119 N5852BShaw David V · Colville, WABuilt 1956 · S/N 33852 N5852FAlvidrez Investments Group Inc · Lakewood, CABuilt 1967 · S/N 21058852 N5852GSwigart Davis Holdings Inc · Upland, CABuilt 1969 · S/N 15071352 N5852RBenien Dennis A · Napoleon, OHBuilt 1965 · S/N 17253521 N5853ADanz Frederick C · Mattawa, WABuilt 1956 · S/N 28453 N5853GJohnson Robert K · Monte Rio, CABuilt 1969 · S/N 15071353 N5853RHall Gary M · Muncie, INBuilt 1965 · S/N 17253522 N58546Satara Inc · Frisco, TXBuilt 1973 · S/N 18262130 N58548Khbp LLC · Donnelly, IDBuilt 1973 · S/N 18262132 N58549Sale Reported · Rio Rico, AZSale reported, canceledBuilt 1973 · S/N 18262133 N5854BCruson James W · Spring Creek, NVBuilt 1956 · S/N 33854 N58554Mocking Bird Aviation LLC · Hanover, PAS/N 18262137 N58558Long William E · Old Town, FLBuilt 1973 · S/N 18262139 N5855BCudahy J Patrick · Bayside, CABuilt 1956 · S/N 33855 N5855FOrmiston Air LLC · Kismet, KSBuilt 1967 · S/N 21058855 N5855RDonelan Matt B · Springfield, ILBuilt 1965 · S/N 17253524 N58560N58560 LLC · Zionsville, INBuilt 1973 · S/N 18262140

Back to AD 87-20-03 R2