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.

N46MPAnderson Howard E · Luray, VABuilt 1983 · S/N 172RG1144 N46MRDavin Matthew · Ridgecrest, CABuilt 1975 · S/N 21060778 N46PCMace Robert C Jr · Gold Canyon, AZS/N 21060105 N46PGRegistered aircraftBuilt 1972 · S/N 18261414 N46PKTensas Taildraggers LLC · Saint Joseph, LABuilt 1978 · S/N U20604437 N4700FAssociated Equip Representatives Inc · Yakima, WABuilt 1966 · S/N P206-0300 N4700SGiddyup Flyers LLC · Danville, CABuilt 1979 · S/N R18201388 N4700XCerasia Steven S · Amsterdam, NYBuilt 1966 · S/N 15064750 N4701DMiller Larry L · Dade City, FLBuilt 1957 · S/N 34801 N4701QWindsor Greg A · Anchorage, AKBuilt 1966 · S/N 185-1155 N4701SBailey Mark E · Owingsville, KYBuilt 1979 · S/N R18201389 N4701URegistered aircraftBuilt 1964 · S/N 18051401 N47028My Way Aviation LLC · Weston, FLS/N 15283159 N47029Geronimo Aviation LLC · Scottsdale, AZBuilt 1979 · S/N 15283160 N4702FSouthern Aces LLC · Geneva, FLBuilt 1979 · S/N 17273074 N4702KUniversity Auto Sales Inc · Pell City, ALBuilt 1975 · S/N 18263701 N4702PWings Over Texas Holdings LLC · Denton, TXBuilt 1980 · S/N 15284801 N4702QDriggs Daniel H · Anchorage, AKBuilt 1966 · S/N 185-1156 N4702WFour Flying Fools LLC · Geneva, FLS/N 57532 N4703KSkeffington Robert C · Topsfield, MABuilt 1975 · S/N 18263702 N4704ABrown Helicopter Inc · Pensacola, FLBuilt 1974 · S/N 18502426 N4704CWright Brian A · Nampa, IDBuilt 1956 · S/N 33738 N4704GRegistration Pending · Spencerville, OHRegistration pendingS/N 17273326 N4704HWest Bend Air Inc · West Bend, WIBuilt 1979 · S/N 15283966 N4704NScott Lester N · Pleasanton, CAFirst renewal noticeBuilt 1979 · S/N 18267294 N4704XHighsmith Michael D · Chipley, FLBuilt 1966 · S/N 15064754 N47053Semagin Arkadi · Burlingame, CABuilt 1979 · S/N 15283163 N4705DN4705d LLC · Oklahoma City, OKS/N 17272335 N4705HWest Bend Air Inc · West Bend, WIBuilt 1979 · S/N 15283967 N4705KYi Ranches Lp · Reedley, CABuilt 1975 · S/N 18263704 N4705NBrentco Aerial Patrol Inc · Canton, OHBuilt 1979 · S/N 18267295 N4705QWings Over Texas Holdings LLC · Denton, TXBuilt 1981 · S/N 152-85053 N4705UIverson James P · Soldotna, AKBuilt 1964 · S/N 18051405 N4706BCollegiate Peaks Aviation LLC · Salida, COBuilt 1955 · S/N 31604 N4706DKelly William W · Springfield, ORBuilt 1979 · S/N 17272336 N4706KWitman Michael R · Milliken, COBuilt 1975 · S/N 18263705 N4706NReef Clipper LLC · Pittstown, NJS/N 18267296 N4706QRegistration Pending · Polson, MTRegistration pendingBuilt 1966 · S/N 185-1160 N4706SGreat Lakes Aviation LLC · Burtchville, MIBuilt 1979 · S/N R18201392 N4706XKey Joseph E · Eltopia, WABuilt 1966 · S/N 15064756 N4707BOlathe Spray Service Inc · Olathe, COBuilt 1955 · S/N 31605 N4707KKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1975 · S/N 18263706 N4707LJet & Rotor Aviation LLC · Sacramento, CABuilt 1980 · S/N 15284222 N4707NBrandon Gregory R · Talking Rock, GAS/N 18267297 N4707SBas Part Sales LLC · Greeley, COBuilt 1979 · S/N R18201393 N4707TVan Ausdall John C · Spring Branch, TXBuilt 1981 · S/N R18201739 N4707UZero Seven Uniform LLC · Palmer, AKBuilt 1964 · S/N 18051407 N4707VWhite Timothy C · Grapevine, TXS/N 7275 N47084Tabor Peter C · Durango, COBuilt 1975 · S/N 18263783 N4708NSkylane LLC · Billings, MTBuilt 1979 · S/N 18267298

Back to AD 87-20-03 R2