OpenAirDocs.org
AD 87-08-08 R3

Registered aircraft · 22,416

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
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-08-08-R3')
    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-08-08-R3')
  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.

N7109WV1 Air Inc · Hibbing, MNS/N 28-897N710APa28 Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843766N710AWBrown Dustin · Rossburg, OHBuilt 1966 · S/N 32-473N710BTMunoz Tanen J · Lockeford, CABuilt 1970 · S/N 32-1295N710CAChristiansen Aviation LLC · Wilmington, DEBuilt 2024 · S/N 2881730N710RDPurll Samuel B · Mechanicsville, MDBuilt 1966 · S/N 28-21809N710UBoard Of Regents Of University Of Oklahoma · Norman, OKBuilt 2025 · S/N 28020229N7110RQuale Eric L · Everett, WABuilt 1966 · S/N 28-21806N7111RGreen Michael W · Helena, ARS/N 28-21810N71128Eastern Stearman Inc Trustee · Leesburg, VABuilt 1972 · S/N 28-7225450N7112CEmbry Vantha C · Knoxville, TNS/N 28-7690056N7112RMarshall Air LLC · Bellevue, MIBuilt 1966 · S/N 28-21811N7112WKeesee Bill · Meadow, TXBuilt 1962 · S/N 28-903N7113RNewton Dennis E · Surprise, AZBuilt 1966 · S/N 28-21812N7113WHigh Flyers Inc · Benson, AZS/N 28-961N71141Av8 Flight Assets LLC · Eden Prairie, MNBuilt 2017 · S/N 2843910N71143Av8 Flight Assets LLC · Eden Prairie, MNBuilt 2017 · S/N 2843911N7114AMy Air Mira LLC · Eagan, MNBuilt 2017 · S/N 2843912N7114CAv8 Flight Assets LLC · Eden Prairie, MNBuilt 2017 · S/N 2843913N7114JAv8 Flight Assets LLC · Eden Prairie, MNBuilt 2017 · S/N 2843914N7114WEstes Shannon L · Pace, FLBuilt 1962 · S/N 28-905N7115LAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843915N7115WLambert Scott E · Shamong, NJBuilt 1962 · S/N 28-906N7116RBastian Dennis L · Burns, WYBuilt 1966 · S/N 28-21816N7117WMitchell Cameron A · Hopkinsville, KYBuilt 1962 · S/N 28-908N711ABL J S Enterprises Inc · Albany, TXBuilt 1969 · S/N 28R-35189N711AZGriffith Grading Co Inc · Newnan, GABuilt 1970 · S/N 28-11361N711BDCoburn Eric E · Leesburg, INFirst renewal noticeBuilt 1972 · S/N 28-7205271N711CKStecker Tyler J · Spokane, WABuilt 1979 · S/N 28-7911159N711CVSmtm Holdings Inc · Wilmington, DEBuilt 1971 · S/N 28R-7135212N711EMBlue Sky Jet Services LLC · Lititz, PABuilt 1978 · S/N 32R-7885231N711FLFernandez Kevin · Fuquay Varina, NCBuilt 1972 · S/N 28-7225327N711JLCentral Iowa Agricultural Aviation LLC · Wellsburg, IABuilt 1973 · S/N 32-7340175N711NDFlight Leasing Corp · Wilmington, DEBuilt 2017 · S/N 2843881N711PFTaylor Monty · Kingfisher, OKS/N 32-7340061N711TYTas Technical Consulting Inc · Schaumburg, ILS/N 28R-7703025N7122JCarrizales Chad A · Jacksonville, ARBuilt 1973 · S/N 32-7300032N7122RSimmons Heating And Air Conditioning LLC · Summerville, SCBuilt 1966 · S/N 28-21823N7123WHarvick Wayne P II · Kenmore, WABuilt 1962 · S/N 28-920N7124RNewsome Thomas D · Canal Winchester, OHBuilt 1966 · S/N 28-21825N7124WTuchols John E · Lockport, NYBuilt 1962 · S/N 28-921N7125WRavelli Sidney · Salem, OHBuilt 1962 · S/N 28-922N7126RLeonard Justin P · Charleston, SCBuilt 1966 · S/N 28-21827N7127RGreen William A · Memphis, TNS/N 28-21828N7128WVan Curen Mary Ann · Owasso, OKS/N 28-925N7129RLinn Stephen K · Evergreen, COBuilt 1966 · S/N 28-21830N712LDBurns William J · Onalaska, WIBuilt 1982 · S/N 32-8206034N712PWDown The Creek LLC · Grant Valkaria, FLBuilt 1976 · S/N 32R-7680276N7130WRoye Bart L · Slaton, TXBuilt 1962 · S/N 28-928N7132RGreydanus Samuel E · Holland, MIBuilt 1966 · S/N 28-21833
Back to AD 87-08-08 R3