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.

N4775KBas Part Sales LLC · Greeley, COBuilt 1979 · S/N P21000306 N4775NTennessee Metals Recycling LLC · Murray, KYBuilt 1979 · S/N 18267358 N4775QShelk John Brian · Bend, ORBuilt 1967 · S/N 185-1242 N4775UBishop Mike · Rifle, COBuilt 1964 · S/N 18051475 N4776BLarsen Christopher F · Fairbanks, AKBuilt 1955 · S/N 31674 N4776EAlpha One Aviation LLC · Dunedin, FLBuilt 1978 · S/N 17271641 N4776NRegistration Pending · Ceiba, PRRegistration pendingBuilt 1979 · S/N 18267359 N4776THigh Planes Air Service · Bismarck, NDBuilt 1981 · S/N R18201762 N4776UHabberstad John L · Rathdrum, IDBuilt 1979 · S/N U20605096 N4776XMersiowsky Richard R · King George, VABuilt 1966 · S/N 15064826 N4777HMorey Airplane Co Inc · Middleton, WIBuilt 1979 · S/N 15283978 N4777NRosario Edwin A · Pine Island, NYBuilt 1979 · S/N 18267360 N4777SN4777s LLC · Ault, COBuilt 1980 · S/N R18201424 N4777UAdair Aviation LLC · Broken Arrow, OKBuilt 1983 · S/N 21064814 N4778EClemmons Flyers LLC · Green Cove Springs, FLS/N 17271643 N4778FPond Engineering Laboratories Inc · Berthoud, COBuilt 1967 · S/N P206-0378 N47791Schwartz John E · Ventura, CABuilt 1979 · S/N 15283250 N47793Taylor Jimmie D · Hedley, TXBuilt 1965 · S/N 15061406 N4779TAmerican Aerial Patrol LLC · Saint Amant, LABuilt 1981 · S/N R18201764 N4779UBergh Eugene H · Roberts, WIBuilt 1964 · S/N 18051479 N4779XSnodgrass James T · Gallipolis, OHBuilt 1966 · S/N 15064829 N477ALSimply Living LLC · Fort Myers, FLBuilt 1969 · S/N 17701285 N477FReu Aviation LLC · Columbia, SCS/N 17265266 N477MAThompson Layne A · Pollok, TXBuilt 1981 · S/N 21064291 N47808Colgan Aviation LLC · La Crosse, WIBuilt 1979 · S/N 15283253 N4780ECarolinas Aviation LLC · North Myrtle Beach, SCBuilt 1978 · S/N 17271645 N4780RR&R Flight Services Inc · Mendota, ILBuilt 1975 · S/N 18802319 N4780XBroyles Dean L · Pittsboro, INBuilt 1966 · S/N 15064830 N4781DGipe Douglas A · Malvern, IABuilt 1958 · S/N 34881 N4781NRobwin Air LLC · Lutz, FLBuilt 1979 · S/N 18267364 N4781QStocker Russell · Woodland, CAS/N 18802523 N4781XMartinez Ivan A · Oro Valley, AZBuilt 1966 · S/N 15064831 N4782DSwalling Matthew C · Wasilla, AKBuilt 1958 · S/N 34882 N4782RSchulert Peter A · Lebanon, TNBuilt 1979 · S/N 172RG0030 N4783BRogge Gary L · Fowler, COBuilt 1955 · S/N 31681 N4783KLandwehr Wayne A · Gill, COBuilt 1979 · S/N P21000314 N4783NPlane Sense LLC · Oregon City, ORBuilt 1979 · S/N 18267366 N4784AFox Aviation International Inc · Justin, TXBuilt 1979 · S/N A1520891 N4784BPhyfe Andrew L · Cape Coral, FLBuilt 1955 · S/N 31682 N4784EPeabody Jeffery L · Vinemont, ALBuilt 1978 · S/N 17271649 N4784FSullivan Ross Anthony · Saint Helena, CAS/N P206-0384 N4784XOgletree Ben R Jr · Livingston, TXBuilt 1966 · S/N 15064834 N47856Vector-USA LLC · Olive Branch, MSBuilt 1979 · S/N 15283258 N4785BBravo Zulu Aviation LLC · Torrance, CAS/N 15283633 N4785NHolden Engineering Inc · Oviedo, FLBuilt 1979 · S/N 18267368 N4785SSchiller Matt D · San Francisco, CABuilt 1979 · S/N R18201426 N4785UNew England Vascular Access LLC · Bristol, NHBuilt 1983 · S/N 21064816 N4786DPierce Stephan L · Graham, TXBuilt 1958 · S/N 34886 N4786ETu Erik S · Pasadena, CABuilt 1978 · S/N 17271651 N4786FLogan Robert E · Advance, NCBuilt 1968 · S/N P206-0470

Back to AD 87-20-03 R2