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

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

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.

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

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.

N799JHInternational Air Services Inc Trustee · Carson City, NVBuilt 1982 · S/N 28R-8231051 N79AFBritsch Uwe K · Klamath Falls, ORBuilt 1979 · S/N 28R-7931265 N79ANAra Aviation Management LLC · Bensalem, PAS/N 32-8024005 N79AUEpsman Kenneth A · Santa Clara, CABuilt 2007 · S/N 3257463 N79FYManaj Aviation LLC · Wilmington, OHBuilt 1979 · S/N 32-7940200 N79HKHughes Theodore · Maryville, TNBuilt 1979 · S/N 28R-7918154 N79MSUaa International Inc · La Verne, CABuilt 1978 · S/N 28-7990154 N79NANorthampton Aeronautics Inc · Northampton, MABuilt 1977 · S/N 28-7816276 N79NCLiam Clerkin Inc · Wilmington, DEBuilt 1979 · S/N 327940249 N79PAFlightgest Academy LLC · Morrisville, NCBuilt 2020 · S/N 2881293 N79PXOcerg Holdings LLC · Springdale, PAS/N 32-7940206 N79SFSterling Flight Training LLC · Jacksonville, FLS/N 2881378 N79UReichert John · Port Orange, FLBuilt 1979 · S/N 28R-7931266 N79VM3 Itg Aviation LLC · Allentown, NJBuilt 1969 · S/N 28R-35230 N79WCElmer Wayne A · Battle Lake, MNBuilt 1975 · S/N 28-7615069 N7FMAppalachian Racing Aviation LLC · Johnson City, TNBuilt 1971 · S/N 32-7240041 N7HXBlairtogaii Inc · Novi, MIBuilt 1982 · S/N 32-8224005 N7JJKarmel Moshe · Aventura, FLBuilt 1974 · S/N 28R-7435287 N7MEAzary Zoltan D · Occidental, CAS/N 28R-8131026 N7SKhashimkhodjaev Rustam · Parker, COBuilt 1977 · S/N 28R-7703050 N7SXBennett Mark A · Markleville, INBuilt 1966 · S/N 32-309 N7UULazy R Endeavors LLC · Orient, OHS/N 2843139 N7VBDeeb Inc · Port Richey, FLBuilt 1976 · S/N 28R-7635330 N7VWSantoro Joseph A · Phoenix, AZBuilt 1977 · S/N 28-7890145 N7XACine Aviation Inc · W Bloomfield, MIBuilt 1981 · S/N 32R-8229020 N80018Schurenstedt Carl R · Vail, COS/N 28R-8131172 N8001WKebely Brian M · Newbury Park, CABuilt 1964 · S/N 28-2061 N8003WBas Part Sales LLC · Greeley, COBuilt 1964 · S/N 28-2063 N8004MEuroaviation Inc · KematenBuilt 1981 · S/N 28R-8231017 N8004NHigh Noon Leasing LLC · Anchorage, AKBuilt 1981 · S/N 32-8206014 N8004WBaker Cliff W · Wills Point, TXBuilt 1964 · S/N 28-2065 N8005KShahan Nathan C · Heath, TXBuilt 1981 · S/N 32-8224003 N8006NClear Skies Aviation Inc · Montgomery, TXBuilt 1968 · S/N 28-25247 N8006QBramley Eric M · Avondale Estates, GABuilt 1981 · S/N 32R-8213016 N8006WTurnbull Lee M · Uniondale, NYS/N 28-2067 N8007Fedorko David · Tampa, FLS/N 28-3225 N8007BHart Adventures LLC · Riverside, ALBuilt 1981 · S/N 32R-8213017 N8007WMoreau Claude J · Moneta, VABuilt 1964 · S/N 28-2068 N8008NHudson Maury B · Humble, TXBuilt 1968 · S/N 28-25249 N8008WHockett Patricia A Trustee · Granbury, TXBuilt 1965 · S/N 28-2069 N8009NSchenkat Mark H · Baraboo, WIBuilt 1968 · S/N 28-25250 N8009W282 Rsa LLC · Naples, FLBuilt 1964 · S/N 28-2071 N800CTPakiri Aviation LLC · San Antonio, TXBuilt 1981 · S/N 28-8290069 N800FWPaphos Airways LLC · Farmingdale, NYS/N 28-8216060 N800HSVertical Horizon Aviation LLC · Sandown, NHBuilt 2001 · S/N 3257246 N800SLParagon Airplane Leasing Co · Fort Myers, FLBuilt 2024 · S/N 28020192 N800TCAmericas Choice Properties LLC · Talbott, TNBuilt 1980 · S/N 32-8106001 N800TMMmm Fliers LLC · South Bend, INBuilt 1979 · S/N 32R-7985088 N800VVCarver Aero LLC · Muscatine, IABuilt 1981 · S/N 28-8216080 N8010WAustin Steven · Navasota, TXBuilt 1964 · S/N 28-2072

Back to AD 87-08-08 R3