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.

N7847CAyres Patrick C · Bend, ORBuilt 1954 · S/N 31046 N7847UFinnegan James M · West Valley City, UTBuilt 1964 · S/N 17251847 N7847XNix Charles W · San Jose, CABuilt 1961 · S/N 17248347 N78482N78482 LLC · Granbury, TXS/N 17257632 N78487Richardson David · Leitchfield, KYS/N 17257635 N78489Tanner Richard L · Copperhill, TNBuilt 1968 · S/N 17257636 N78490Owens Neil L Jr · Tallapoosa, GAS/N 17257637 N78491El Dorado Rentals Inc · El Dorado Springs, MOBuilt 1968 · S/N 17257638 N78494Peterson Darwin D · Antler, NDBuilt 1968 · S/N 17257640 N7849TMyers Stanley · Portland, ORBuilt 1960 · S/N 47449 N7849ZMorgan Gregory A · Rice, VABuilt 1963 · S/N 15059949 N784AWSea Rogue Enterprises Inc · Greenville, MEFirst renewal noticeBuilt 1973 · S/N 18502251 N784CRTurnipseed Kenny A · Sumner, TXS/N 17257629 N784DJAlta Volare LLC · Wilmington, DEBuilt 1968 · S/N 21059104 N784GHenry Frank P · Winnabow, NCBuilt 1977 · S/N 18265960 N784GTMarianas Air Transfer Inc · Tinian, MPBuilt 1977 · S/N 17268855 N784LMNorth Lake Air LLC · Lindstrom, MNBuilt 1979 · S/N 18267452 N784REsmaili Farid · Woodstock, VAS/N 17271233 N7850GWhitfield Robert O Jr · Hurdle Mills, NCS/N 17259550 N7850UJohnson Lawrence F · Sacramento, CABuilt 1964 · S/N 17251850 N7850ZBenscoter Richard S · Nordman, IDBuilt 1963 · S/N 15059950 N78512United States Air Force Academy Aero Club · Usaf Academy, COBuilt 1969 · S/N 17257646 N78513Reeder Gary T · Galena, OHBuilt 1968 · S/N 17257647 N78515Becker Jarrod L · Selfridge, NDBuilt 1968 · S/N 17257648 N78517Johnson Kevin R · Gladstone, ORBuilt 1968 · S/N 17257650 N7851FDevries James E · Bejou, MNBuilt 1966 · S/N 15063951 N7851UR & S Aviation LLC · Corning, ARBuilt 1964 · S/N 17251851 N78520Jdb Aviation Inc · Merritt Island, FLBuilt 1968 · S/N 17257651 N78522Jb522 LLC · Pflugerville, TXBuilt 1973 · S/N 18261768 N78523Sunderman Randy · Norfolk, NEBuilt 1968 · S/N 17257653 N78525Aero II Inc · Spartanburg, SCBuilt 1969 · S/N 17257655 N78526Miklus Michael III · Saint Georges, DEBuilt 1968 · S/N 17257656 N7852UMartinson James C · Sioux Falls, SDBuilt 1964 · S/N 17251852 N7852ZKvservices LLC · Buckley, WABuilt 1963 · S/N 15059952 N78531Goodridge Flying Club Inc · Goodridge, MNBuilt 1968 · S/N 17257658 N78538Drover Michael A · Winter, WIBuilt 1968 · S/N 17257660 N7853ARegistered aircraftBuilt 1957 · S/N 32750 N7853FEdwards Michael J · Hazlehurst, GABuilt 1966 · S/N 15063953 N7853TBailey Ned A · Friday Harbor, WABuilt 1960 · S/N 47453 N78542Tolmachev Nikolay A · Anchorage, AKBuilt 1968 · S/N 17257661 N78548Bakalar Flying Club Inc · Columbus, INBuilt 1968 · S/N 17257662 N7854AMacglover Richard A · Ham Lake, MNBuilt 1957 · S/N 32751 N7854GNeuschaefer George H · White Hills, AZBuilt 1970 · S/N 17259554 N7854ZAdams Jerry W · Dallas, TXBuilt 1963 · S/N 15059954 N78553Shop Branch Equipment Co Inc · Marble Falls, TXBuilt 1968 · S/N 17257666 N78556B&T Venutres LLC · Duncan, OKBuilt 1973 · S/N 18261769 N7855CSitz Walter L · Burns, ORBuilt 1959 · S/N 31440 N7855FSmith Joshua B · Kenai, AKS/N 15063955 N7855GAlpenglow Air 3 LLC · Anchorage, AKBuilt 1970 · S/N 17259555 N7855XBensema Amber L · Winchester, CAS/N 17248355

Back to AD 87-20-03 R2