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.

N50379Grosdidier Rolland J · Kenai, AKBuilt 1968 · S/N 15069263 N5037DC & R Leasing LLC · Fairbanks, AKBuilt 1958 · S/N 51137 N5037EDevore James L · Carmichael, CABuilt 1958 · S/N 50337 N5037RJlinn Aviation Inc · Quinlan, TXBuilt 1974 · S/N 17263278 N5037VPoh Enterprises LLC · Gardena, CABuilt 1975 · S/N 21060824 N50382Eastside Aero Inc · Eatonville, WABuilt 1968 · S/N 15069264 N5038RKnecht Ken L · Eagle River, AKBuilt 1976 · S/N 18502985 N50390Dillard Clayton B · Talkeetna, AKBuilt 1968 · S/N 15069269 N5039ASutton Aircraft Salvage LLC · Palmer, AKBuilt 1955 · S/N 28039 N5039DUp Above Ak LLC · Wasilla, AKBuilt 1958 · S/N 51139 N5039HBig Mountain Aviation Inc · Whitefish, MTBuilt 1975 · S/N 17265311 N5039RSmooth Landings Inc · Cary, ILBuilt 1974 · S/N 17263280 N503AMAlpha Aviation LLC · Spartanburg, SCBuilt 1982 · S/N 17275767 N503ATRegistered aircraftBuilt 1975 · S/N 21060924 N503CAThompson Paul W Jr · Yachats, ORBuilt 1974 · S/N 17263757 N503ETar Dennis W · Summerfield, NCBuilt 1956 · S/N 28361 N503MAHobart Aviation Inc · Akron, OHBuilt 1975 · S/N 17266089 N503MDChristy John R · Anchorage, AKBuilt 1963 · S/N 206-0076 N503SDSimmons Mark · Madison, MSFirst renewal noticeBuilt 1974 · S/N 15076056 N503STN503st LLC · Royal Oak, MIBuilt 1959 · S/N 50583 N503TCForetich Joseph J · Baker, LAS/N 15069261 N503WAThree Rivers Aero Inc · Three Rivers, MIBuilt 1975 · S/N 17265025 N50400Bostick Alva D H · Portsmouth, OHBuilt 1968 · S/N 15069274 N50403Reis Gavin · Conway, SCS/N 15069277 N50404Mcflight Aviation LLC · Highland, UTBuilt 1968 · S/N 15069278 N50405Und Aerospace Foundation · Grand Forks, NDBuilt 1968 · S/N 15069279 N50406Aeroplanes Over Idaho Inc · Carson City, NVS/N 15069280 N50407Coombs Kevin A · Knoxville, TNS/N 15069281 N5040APark Kyle Hunter · Jefferson City, MOS/N 28040 N5040RShirley Craig T · Ennis, MTBuilt 1974 · S/N 17263281 N5040UAir Data Solutions LLC · Natchitoches, LABuilt 1963 · S/N 206-0040 N50413Rafi Adnan · Olean, NYS/N 15069286 N50418Forrest City Aircraft Club · Rockton, ILS/N 15069289 N50419Hamilton Richard Paul · Laredo, TXBuilt 1968 · S/N 15069290 N5041AMccollough Bruce S · Skandia, MIBuilt 1955 · S/N 28041 N5041D5041 Delta LLC · Three Forks, MTBuilt 1958 · S/N 51141 N5041EApm Leasing LLC · Casper, WYS/N 17271696 N5041HSimplifly LLC · Mesa, AZBuilt 1975 · S/N 17265313 N5041RBdc Products Inc · Glendale, AZBuilt 1978 · S/N R18200629 N50421Franco Gary R · Chico, CABuilt 1968 · S/N 15069291 N50425Keneston Mark G · Ballston Spa, NYBuilt 1968 · S/N 15069295 N5042RLemieux Michael H · Methuen, MABuilt 1974 · S/N 17263283 N50431Board Susan W · Moundsville, WVBuilt 1968 · S/N 15069298 N50432Mountain Air Flying Club Inc · Clarksburg, WVBuilt 1968 · S/N 15069299 N50434Summerville Daniel · Millersville, MDBuilt 1968 · S/N 15069301 N50438Roche Thomas A · Bardstown, KYBuilt 1968 · S/N 15069303 N5043AStephens Zachary L · Big Lake, AKS/N 28043 N5043RRegistered aircraftBuilt 1974 · S/N 17263284 N5044APatzanakidis Konstandinos · Jupiter, FLBuilt 1955 · S/N 28044 N5044DCarpenter Corey · Warden, WAS/N 51144

Back to AD 87-20-03 R2