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.

N9175ZMoeckel John H · North Venice, FLBuilt 1989 · S/N 2803003 N9176JPayson Aero Club LLC · Payson, AZBuilt 1966 · S/N 28-3242 N9176NWjr Aviation Inc · Caledonia, MIBuilt 1989 · S/N 3213025 N9177WBartels Gary A · Daykin, NEBuilt 1966 · S/N 28-10833 N9178JCrawley Rohan · Bloomington, INS/N 28-3244 N9178WBoyd Dean W · Merrill, WIBuilt 1966 · S/N 28-10834 N9179WVangura David · Ponte Vedra Beach, FLBuilt 1966 · S/N 28-10835 N917DKEncore Jet Management LLC · San Antonio, TXBuilt 1998 · S/N 2843186 N917TCDebarros David · Ashland, VABuilt 1998 · S/N 2843167 N9180DSan Souci Holdings LLC · Reisterstown, MDS/N 2837014 N9180HPiper Aircraft Inc · Vero Beach, FLS/N 2837015 N9181DBoehmer Transportation Corporation · Machias, NYBuilt 1989 · S/N 2811029 N9181WSkyward Horizons LLC · Maumelle, ARBuilt 1966 · S/N 28-10837 N9182JTremblay Christopher A · Albion, MEBuilt 1966 · S/N 28-3250 N9182KRoth Howard R · Mott, NDBuilt 1976 · S/N 28-7625169 N9182QFox Terrier LLC · Wilmington, DEBuilt 1989 · S/N 3213028 N9182WMoyer Aviation Inc · Tobyhanna, PABuilt 1989 · S/N 2841130 N91834Skylink Xpress Inc · San Bernardino, CABuilt 1989 · S/N 2841141 N9183WAerolina Inc · Hendersonville, NCBuilt 1989 · S/N 2837024 N91853Eminess Group LLC · Bradenton, FLBuilt 1989 · S/N 3213030 N9185JRatcliff Dale A · Granville, OHBuilt 1966 · S/N 28-3253 N9185WFixed Gear Aviation LLC · Eldersburg, MDBuilt 1966 · S/N 28-10842 N9186KMock Joseph R · Huntsville, TXBuilt 1976 · S/N 28-7615181 N9186XRohrbaugh John M Jr · Warrenton, VABuilt 1993 · S/N 2811037 N9188JBooth Emmett W · Waitsburg, WAS/N 28-3256 N9188WDc Engineering Inc · Meridian, IDBuilt 1967 · S/N 28-10846 N9189JMileski William J · Ledyard, CTBuilt 1966 · S/N 28-3257 N918AGPeregrine Howard Aeroflight Owner LLC · New Orleans, LABuilt 2025 · S/N 2881947 N918ASFarley Scott S · Ellington, CTBuilt 1998 · S/N 3257029 N918GArcher Flight LLC · Wilmington, DEBuilt 2018 · S/N 2881074 N918LPowers Aircraft Sales And Leasing Inc · Longwood, FLBuilt 2000 · S/N 3246162 N918MANewman Aviation Services Inc · Tiffin, OHBuilt 1998 · S/N 3246118 N918PABird Acquisition LLC · Phoenix, AZBuilt 1999 · S/N 2843307 N9190AAhlhorn Travis · New Braunfels, TXBuilt 1989 · S/N 32R-7887064 N9190JLarchar William S · Rockledge, FLS/N 28-3258 N9191DPorter William C Jr · Vicksburg, MSS/N 3213032 N9191JArmstrong Donald Bradford · Sterling, COBuilt 1966 · S/N 28-3259 N9191N9191n LLC · Salem, NHBuilt 1989 · S/N 2890136 N9191VMilville Aviation LLC · Wilmington, DEBuilt 1989 · S/N 3213033 N9191WTransonic Management Inc · Plattsmouth, NES/N 28-10849 N9192VPlane Fun Inc Tr Trustee · Snellville, GABuilt 1965 · S/N 28-3268 N9193JGref Michael C · Murfreesboro, TNBuilt 1966 · S/N 28-3261 N9193WFritcher Michael S · Arlington, TXBuilt 1967 · S/N 28-10851 N9194JStange Robert C · Toledo, OHBuilt 1966 · S/N 28-3262 N9194WWatson Paul F · Galloway, NJS/N 28-10852 N9194YBanner Jeffrey D · Grove City, PABuilt 1985 · S/N 28-8511007 N9195JLau-Camarena Alvaro · Euless, TXBuilt 1966 · S/N 28-3263 N9195KWatson Joseph L Jr · Concord, NCBuilt 1976 · S/N 28-7690227 N9195WMcguire Aviation LLC · Kalispell, MTBuilt 1967 · S/N 28-10853 N9196JScarlett Seth T · Omaha, NEBuilt 1966 · S/N 28-3264

Back to AD 87-08-08 R3