Registered aircraft · 22,413

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.

N3861WMendez Fidel Serrano · San Sebastian, PRBuilt 1966 · S/N 32-804 N38628Maxair Inc · Coxs Creek, KYBuilt 1977 · S/N 28-7790572 N38629Red Tail Scholarship Foundation · Tuskegee, ALBuilt 1977 · S/N 28-7790573 N3862KNeihart Randy L · Fontana, CABuilt 1967 · S/N 28-23753 N3862MN3862m LLC · Provo, UTS/N 28-7890337 N3862THanson John M · Wht Sphr Spgs, MTBuilt 1967 · S/N 28R-30185 N38632Tappan Michael L · Miamisburg, OHBuilt 1977 · S/N 28R-7737103 N38636Fre Investments LLC · Enterprise, ALBuilt 1977 · S/N 28R-7703253 N38639Mccullough Peter Lee · Doylestown, PABuilt 1977 · S/N 28R-7703255 N3864MAscent Aviation LLC · Van Nuys, CABuilt 1978 · S/N 28-7890338 N3864TPatton Aviation LLC · Billings, MTBuilt 1967 · S/N 28R-30187 N38655Wensmann Joel · Sartell, MNBuilt 1977 · S/N 28R-7737105 N38656Allen James R · Olympia, WABuilt 1977 · S/N 28-7716272 N38657W I F A (Washington International Flight Acad) LLC · Gaithersburg, MDBuilt 1977 · S/N 28-7790574 N3865WWestenberger David L · Indianapolis, INBuilt 1966 · S/N 32-809 N38664Aerostyles LLC · Colorado Springs, COS/N 28R-7703259 N3866RDurgin William W · Waquoit, MABuilt 1970 · S/N 28-5845 N3866TVacracos James L · Saint John, INBuilt 1967 · S/N 28R-30189 N3866WN3866w LLC · Broken Arrow, OKBuilt 1966 · S/N 32-810 N38674Tse Aircraft LLC · Jacksonville, FLBuilt 1977 · S/N 32R-7780459 N38677Bass Michael L · Mount Olive, NCBuilt 1977 · S/N 32-7840024 N3867TSater Travis D · Salem, ORBuilt 1967 · S/N 28R-30190 N3867WN3867w LLC · Clemson, SCBuilt 1966 · S/N 32-811 N3868RGentry Donald R · Welaka, FLBuilt 1969 · S/N 28-5770 N38692Markis Dean · Lake Worth, FLBuilt 1977 · S/N 28-7725263 N38694Chapman Daniel H · Yucaipa, CABuilt 1977 · S/N 28-7790576 N38696Lake Area Technical College · Watertown, SDBuilt 1977 · S/N 28-7790577 N3869TSix Niner Tango LLC · Spartanburg, SCBuilt 1967 · S/N 28R-30193 N386DNational Training 1 LLC · Wilmington, DEBuilt 2016 · S/N 2843848 N386NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2023 · S/N 2881678 N38700Universal Aviators Academy Inc · El Monte, CABuilt 1978 · S/N 28-7890001 N38701Sefton James Patrick · Carolina Beach, NCBuilt 1977 · S/N 28R-7703260 N38703Ollieboy Productions LLC · Kalispell, MTBuilt 1977 · S/N 28R-7703261 N38708Holcomb Haydon M · Lamesa, TXBuilt 1977 · S/N 28-7710066 N3870TEast Coast Autoline LLC · Whitehall, PABuilt 1967 · S/N 28R-30194 N38716Spartan Aviation Group LLC · Williamsburg, VABuilt 1977 · S/N 28R-7737109 N38717Meiller Richard S · Kill Devil Hills, NCBuilt 1977 · S/N 28R-7737110 N38718Vgw LLC · Morgantown, WVBuilt 1977 · S/N 28R-7737111 N3871RFly Vermont LLC · Swanton, VTBuilt 1970 · S/N 28-5846 N3871TSzd Property Management LLC · Oceanside, CABuilt 1967 · S/N 28R-30195 N38720Arrow N38720 LLC · West Des Moines, IABuilt 1977 · S/N 28R-7703264 N38725Maynard Geoffrey · New Marlborough, MABuilt 1977 · S/N 32R-7780465 N3872TTucker Zane Griffin · Albany, ORBuilt 1967 · S/N 28R-30196 N38733Lauren Erick · Hollister, CABuilt 1977 · S/N 28-7790580 N38735Schulz Lewis E III · Sand Springs, OKBuilt 1977 · S/N 28-7790581 N3873MMorris Air LLC · Hopkinsville, KYBuilt 1978 · S/N 28R-7803198 N3873TDerby City Aviation LLC · Vero Beach, FLBuilt 1967 · S/N 28R-30197 N3873WBrault David M · Lake Stevens, WABuilt 1966 · S/N 32-819 N38741Hoyda Jeffrey A · Tiffin, OHBuilt 1977 · S/N 28R-7703267 N38746Campbell David A Trustee · Bolivar, MOBuilt 1977 · S/N 32R-7780466

Back to AD 87-08-08 R3