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.

N8641UJohnson Jay A · Lisbon, IABuilt 1965 · S/N 17252543 N8642BCommercial National Flooring Inc · New Carlisle, OHBuilt 1957 · S/N 36342 N8642DAmerican Aviation Inc · Tracy, CABuilt 1979 · S/N 172RG0061 N8642UNemerovsky Jason B · Plantation, FLS/N 15077966 N86438Walleman Benjamin · Macomb, MIBuilt 1973 · S/N 18261933 N8643TStofer William · Warsaw, INS/N 52543 N8643ZVitatoe Industries Inc · Chillicothe, OHBuilt 1967 · S/N P206-0443 N86440Wilde Air Service-Huron LLC · Volga, SDBuilt 1975 · S/N 18802014T N8644BUavionix Corp · Bigfork, MTBuilt 1957 · S/N 36344 N8644GMelin Jeff C · Kenmare, NDBuilt 1965 · S/N 15062744 N8644SRiggan Charles H · Oxford, NCBuilt 1965 · S/N 15061944 N8644UFung Tak C · Ridge, NYBuilt 1965 · S/N 17252546 N8644ZMasters Mission · Nenana, AKBuilt 1967 · S/N P206-0444 N86450Butte Flying Club Inc · Chico, CABuilt 1973 · S/N 18261937 N86452Lazy Ta Legend Aircraft LLC · Wilmington, DES/N 33701199 N8645TLaplante Bruce E · Vilonia, ARS/N 34790 N8645URocereta Aaron W · Eagle River, AKBuilt 1976 · S/N 15077967 N8646QPoe Asphalt Paving Inc · Lewiston, IDBuilt 1976 · S/N U20603462 N8646SFoster Brian E · Bartley, NEBuilt 1965 · S/N 15061946 N8647MWestern Skymasters LLC · Salt Lake City, UTBuilt 1972 · S/N 33701447 N8647QTechnical Applications & Consulting LLC · Topeka, KSBuilt 1976 · S/N U20603463 N8647TJones Wallace F · Waterford, MES/N 52547 N86487Flohr Linn C · Allons, TNBuilt 1969 · S/N 33701207 N8648GAugust Aero LLC · Kalispell, MTS/N 15066728 N8648SSnodgrass Gavin I · Belle, MOS/N 15061948 N8649GMullins Steve F · Belews Creek, NCBuilt 1965 · S/N 15062749 N8649SGuffey Edward B · Bessemer City, NCBuilt 1965 · S/N 15061949 N8649TJarosak Peter J · Valparaiso, INBuilt 1959 · S/N 52549 N864AKNorthern Waters LLC · Livingston, MTBuilt 1980 · S/N 18504066 N864PAMorris David · Fort Mill, SCBuilt 1982 · S/N 172RG1063 N864TGTouch N Go Aeroworks LLC · Greenville, SCS/N 15068527 N864TWTailwinds Academy Of Aviation · Philadelphia, PABuilt 1972 · S/N 17261013 N86508Kalweit Reginald A · Page, AZBuilt 1969 · S/N 33701213 N8650BKing Kenneth M · Charleston, SCBuilt 1957 · S/N 36350 N8650SGrant Clinton A Trustee · Portage Des Sioux, MOS/N 15061950 N8650ZBarry Russell L · Fort Mohave, AZBuilt 1967 · S/N P206-0450 N86510Ungersma Thomas Robert · Belgrade, MTBuilt 1973 · S/N 18261938 N86513Northern Air & Ag Inc · Pollock, SDBuilt 1969 · S/N 33701216 N86526Hill Farms Inc · Drexel, MOBuilt 1973 · S/N 18261941 N8652SKindel Michael W · Bismarck, NDS/N 15061952 N8652TEagles Wings Inc · San Angelo, TXBuilt 1960 · S/N 52552 N86536Moes Crop Dusting Service Inc · Marysville, CABuilt 1973 · S/N 18261942 N86537Beck Kenneth C · Gig Harbor, WABuilt 1969 · S/N 33701227 N86539Skymaster Stc LLC · Mena, ARBuilt 1969 · S/N 33701229 N8653GArmstrong John K · Lovington, NMS/N 15062753 N8653UCurtis Heather · Fairbanks, AKBuilt 1965 · S/N 17252555 N86541Hyppa Russell F · Cook, MNFirst renewal noticeBuilt 1973 · S/N 18261943 N8654UThompson George C · Rogersville, ALBuilt 1965 · S/N 17252556 N8655BFredrickson Sherman E Jr · Norman, OKBuilt 1957 · S/N 36355 N86567Ireys Charles G · Tok, AKBuilt 1976 · S/N 18503128

Back to AD 87-20-03 R2