Registered aircraft · 4,001

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:81-13-10-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:81-13-10-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:81-13-10-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:81-13-10-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:81-13-10-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:81-13-10-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.

N51407Soper Steven Trustee · Rathdrum, IDBuilt 1973 · S/N 1090C N51419Registration Pending · Port Orchard, WARegistration pendingBuilt 1973 · S/N 1093C N51425Black James P · Kooskia, IDBuilt 1973 · S/N 1095C N51430Burke Warren V · Lakewood, COBuilt 1973 · S/N 1097C N51436Boardman Danvers · Talkeetna, AKFirst renewal noticeBuilt 1973 · S/N 1101C N51445Lanier John L · Madison, ALBuilt 1973 · S/N 1106C N51456Saunders David E · Monticello, FLBuilt 1973 · S/N 1107C N51458North Idaho Crushing Inc · Moscow, IDBuilt 1973 · S/N 1114C N51460Sale Reported · Carriere, MSSale reported, pending cancellationS/N 1115C N51463Kelly John Thomas III · Bells, TXS/N 1117C N51464Registered aircraftBuilt 1973 · S/N 6002C N51468Long Dale E · Pimento, INBuilt 1973 · S/N 6008C N51473Miley Gregg E · Melba, IDBuilt 1974 · S/N 6011C N514BCCarlton Bradford Robert · Cape Coral, FLS/N 3449308 N5151ASimmerman Steven C · Memphis, TNBuilt 1968 · S/N 68-6873 N51563Buck Timothy L · Crestview, FLBuilt 1974 · S/N 6015C N51568Brown Jacob Nathaniel · Salt Lake City, UTBuilt 1974 · S/N 6024C N51571Vanwagnen Brian DBA · Jackson, MIBuilt 1974 · S/N 6026C N51578Middle Tennessee State University · Murfreesboro, TNBuilt 1974 · S/N 6020C N51579Whyley Philip C · Encinitas, CABuilt 1974 · S/N 6032C N5157VHarwig Robert P · Longville, MNBuilt 1977 · S/N R1722279 N51608Commonwealth Of Kentucky · Frankfort, KYBuilt 1967 · S/N R1720255 N51631Noguess James E · Deming, NMBuilt 1974 · S/N 6043C N51632Mcguire Dennis B · Howell, MIBuilt 1974 · S/N 6029C N51636Rulewicz Dennis G · Jackson, MIBuilt 1974 · S/N 6045C N51648Esh Christopher J · Girdwood, AKBuilt 1974 · S/N 5032C N51655Clear Blue Marketing Inc · Reno, NVBuilt 1974 · S/N 5039C N517SLLegends Air LLC · Wilmington, DES/N 34-7970114 N51800Southeastern Oklahoma State University · Durant, OKBuilt 2002 · S/N 17281101 N5181ASoutheastern Oklahoma State University · Durant, OKBuilt 2002 · S/N 17281102 N5181BSoutheastern Oklahoma State University · Durant, OKBuilt 2002 · S/N 17281103 N5182AIasco Flight Training Inc · Redding, CABuilt 2002 · S/N 17281106 N519KR519kr LLC · Signal Mountain, TNBuilt 2002 · S/N 1250 N519MKMcleod Martin · Carthage, NCBuilt 2010 · S/N 1099 2010 N51DBSeneca Air LLC · Birmingham, ALFirst renewal noticeBuilt 1978 · S/N 34-7970042 N5205VMcketta Charles W · Moscow, IDBuilt 1977 · S/N R1722283 N521AGRegistered aircraftBuilt 1979 · S/N 25-0139 N521CMShafique Tajammul · Gilford, NHBuilt 2005 · S/N 1558 N521KBJuggyjet Airways LLC · Weehawken, NJBuilt 1978 · S/N 34-7870384 N52202Li Tao · Rancho Cordova, CABuilt 1989 · S/N 25-1204 N5222TRcs Services LLC · California, MDBuilt 1975 · S/N 33701655 N5223JNelson Samuel O · Middletown, OHS/N 25-1172 N5230YSky West Aviation Inc Trustee · Albuquerque, NMS/N 25-1177 N5231VGibson John V Jr · Yardley, PABuilt 1977 · S/N R1722284 N5235VAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2004 · S/N 1417 N524MKKarol Mark · Holmdel, NJBuilt 2003 · S/N 1277 N52515Oscar Deuce LLC · Virginia Beach, VABuilt 1967 · S/N 337M0048 N5252CUtah State University Space Dynamics Laboratory · North Logan, UTBuilt 1967 · S/N 67-21353 N5252GMaxepr LLC · Reno, NVBuilt 1988 · S/N 25-1174 N5252UWhite Wings Ltd · Wilmington, DES/N 25-1171

Back to AD 81-13-10 R1