Skip to content

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.

N38120Hudson Wilburn Joel · Rocky Face, GABuilt 1977 · S/N 28-7790520 N38123Huber Weylin L · Aberdeen, SDBuilt 1977 · S/N 28R-7703178 N38127Trager Limestone LLC · Chillicothe, MOS/N 32R-7780387 N38128Tobias Gregory L · Ottawa Lake, MIS/N 32R-7780388 N3812TGtm Services LLC · Ames, IABuilt 1967 · S/N 28R-30127 N3812WTuned Up Services Inc · Waldo, FLBuilt 1966 · S/N 32-742 N38133White Leroy · Enid, OKS/N 32R-7780389 N3813TCenturion Transportation LLC · Weatherford, OKBuilt 1967 · S/N 28R-30129 N3813WTaylor Bruce W · Stroudsburg, PABuilt 1966 · S/N 32-744 N38146Olson Richard H Trustee · Walla Walla, WAS/N 28-7790241 N38147St Denis Robert G · Lake City, FLBuilt 1977 · S/N 28-7725251 N3814RCarlton Kevin · Mount Vernon, WABuilt 1970 · S/N 28-5835 N3814WN3814w LLC · Maumee, OHBuilt 1966 · S/N 32-745 N3815WCk Aviation LLC · Milledgeville, GABuilt 1966 · S/N 32-746 N3816T1 Vision General Aviation LLC · Sioux City, IABuilt 1967 · S/N 28R-30132 N38177Archer Enterprises Corp · Ossining, NYBuilt 1977 · S/N 28-7790526 N38178Gcs Aero LLC · Laramie, WYBuilt 1977 · S/N 28-7790527 N3818TMccawley Gerald J · Parksley, VABuilt 1967 · S/N 28R-30134 N3818WHeadwinds Maintenance Inc · Fort Pierce, FLBuilt 1966 · S/N 32-750 N38190Classic Aviation Inc · Pella, IABuilt 1977 · S/N 28-7725260 N38193Ramirez Katherin · Homestead, FLBuilt 1977 · S/N 28-7725265 N38194Jhl Financial Services Inc · Montgomery, NYS/N 28-7725268 N38195Inspiration Aviation Ministries · Waterville, MEBuilt 1977 · S/N 28-7716230 N38197Anderson Loran · Cooperstown, NDBuilt 1977 · S/N 28-7716231 N3819TChism Alicia L · Lawrence, KSBuilt 1967 · S/N 28R-30136 N381ABWitt Anthony Joseph · Plymouth, INBuilt 2006 · S/N 3232063 N381BTPiper Aircraft Inc · Vero Beach, FLS/N 28010085 N381CBGrubbs Steven O · Bellaire, TXBuilt 1981 · S/N 32R-8129068 N381DProfessional Training Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 2843844 N381FCBrown Shane · Ozark, MOBuilt 1976 · S/N 28-7615197 N381GAtp Taa LLC · Wilmington, DEBuilt 2020 · S/N 2881429 N381HPHopkins George · West Covina, CABuilt 2005 · S/N 3257374 N381LJBlue Rudder Aviatoin LLC · Excelsior, MNBuilt 2002 · S/N 2843540 N381NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2023 · S/N 2881666 N38200Hauzer Alex · Golden, COBuilt 1977 · S/N 28R-7737083 N38201Touchstone Justin Reed · Hattiesburg, MSS/N 28R-7703188 N38203Wdiaz Design Inc · Sunny Isles Beach, FLBuilt 1977 · S/N 28R7703189 N38204Louw-Defazio Joan Trustee · Temecula, CABuilt 1977 · S/N 28-7710046 N38205Albright John A · Richmond, INBuilt 1977 · S/N 32R-7780403 N38206Bean John R · San Antonio, TXBuilt 1977 · S/N 32R-7780404 N38208Jb Airways LLC · Linden, PABuilt 1977 · S/N 32R-7780405 N3820RAnagnos Nick C · East Moline, ILS/N 28-5836 N3820T3820t Aviation LLC · Fort Smith, ARBuilt 1967 · S/N 28R-30137 N38211Watford Aeroservice LLC · Watford City, NDBuilt 1977 · S/N 28-7716232 N38214Mora Steven T · Corning, CABuilt 1977 · S/N 28-7790530 N3821KSoar Above Flight Solutions LLC · Englewood, TNBuilt 1967 · S/N 28-23739 N3821TDoty David W · Lakeland, FLBuilt 1968 · S/N 28R-30959 N38226Martinex Aviation LLC · Wentzville, MOS/N 32-40281 N3822TVanderblom David Y · Oxford, ALBuilt 1967 · S/N 28R-30139 N3823WCherokee N3823w LLC · Huntsville, ALFirst renewal noticeBuilt 1966 · S/N 32-755

Back to AD 87-08-08 R3