Skip to content

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.

N8184CRouse Michael R · Wilson, NCBuilt 1975 · S/N 28R-7635133 N8184HPedersen Gregory S · Spring Hill, FLBuilt 1980 · S/N 32R-8013083 N8184WBaker John L · Killen, ALBuilt 1965 · S/N 28-2310 N8184XHarding Phyllis · Santa Rosa, CABuilt 1980 · S/N 28-8011074 N81850Arms John · Durango, COBuilt 1983 · S/N 32R-8429004 N81853Hobbs Christopher · Truckee, CABuilt 1980 · S/N 32-8006030 N81858Strohauer Farms Inc · La Salle, COBuilt 1980 · S/N 328006031 N8185CKirkland Kerry G · Spring, TXBuilt 1975 · S/N 32-7640053 N8185NWright Edward J Jr · San Antonio, TXBuilt 1969 · S/N 28-25382 N8185TNavitor Global LLC · Irvington, VAS/N 32-8006025 N8185WAlaska Media LLC · Anchorage, AKBuilt 1980 · S/N 328024017 N8185YCarter Gregory A · Edmonds, WABuilt 1980 · S/N 32-8024018 N81866Wellness Flight LLC · Sarasota, FLBuilt 1980 · S/N 288016305 N8186DAmg Industrial LLC · Ashburn, GABuilt 1980 · S/N 32R-8013051 N8186FN8186f Inc · Danville, INBuilt 1976 · S/N 32R-7780088 N8186NMorris Thomas L · Fairmont, WVBuilt 1969 · S/N 28-25383 N8186WStough Stephen A · Reno, NVBuilt 1965 · S/N 28-2313 N81876Purcell Diane Diez · Baton Rouge, LABuilt 1980 · S/N 28-8090283 N81877Ansen Leasing Co · Boone, NCBuilt 1982 · S/N 32R-8213040 N8187WViroqua Area Flyers Inc · Viroqua, WIS/N 28-2314 N8187XStevenson William E · Holton, KSBuilt 1980 · S/N 28-8016307 N81888Zion Thomas C · Middleboro, MABuilt 1981 · S/N 28-8116285 N8188JCrossbrook LLC · Willoughby, OHBuilt 1982 · S/N 32R-8213041 N8188MSmith Jeffrey E · Dunedin, FLBuilt 1982 · S/N 32R-8229043 N8188TPiper Aircraft Inc · Vero Beach, FLBuilt 1980 · S/N 32R-8029081 N8188WBrewer Jordan L · Waynesboro, TNBuilt 1965 · S/N 28-2315 N81891Garnet Aviation LLC · Fort Worth, TXBuilt 1980 · S/N 28-8090285 N81892Embry Kenneth · Nicholasville, KYBuilt 1980 · S/N 28-8090286 N81894Yellow Dog Mgmt LLC · Fort Worth, TXBuilt 1980 · S/N 28-8090287 N81898Zanetti James D · Rock Springs, WYBuilt 1980 · S/N 28R-8018064 N8189SAirplanes Unlimited LLC · Jackson, TNBuilt 1980 · S/N 28-8016308 N8189WTri-City Mens Health LLC · Prescott, AZBuilt 1965 · S/N 28-2316 N818AHChandler Jerome P · Redondo Beach, CABuilt 1973 · S/N 32-7340126 N818CDGreater Flint Pilots Association Inc · Flushing, MIBuilt 1997 · S/N 2843110 N818DVQuiroz Rene Joseph · Matthews, NCBuilt 1969 · S/N 28-26447 N818HEMaxwell James P · Rolling Prairie, INBuilt 1970 · S/N 28-5832 N818KWBrolan Aviation LLC · Kansas City, MOS/N 28-7615283 N8190WA&M Aviation LLC · Tewksbury, MABuilt 1965 · S/N 28-2317 N81912Chesnut Aviation LLC · Odessa, TXS/N 32-8124027 N81916Rrg Software LLC · Alpine, CABuilt 1980 · S/N 28-8016311 N81919Salz Kenneth · Medford, NYBuilt 1980 · S/N 28-8090289 N8191HPorter John W · Center, TXBuilt 1980 · S/N 32R-8029085 N8191XA&J Aircraft Leasing Inc · Burlington, COBuilt 1980 · S/N 28-8016224 N8192HQuinones Jose · Ocean Ridge, FLBuilt 1980 · S/N 32-8006039 N8192NNaber Adam T · Fort Atkinson, WIBuilt 1969 · S/N 28-25390 N8192QSunshine Industries Inc · Abingdon, VABuilt 1980 · S/N 32-8024020 N8192WHenley Edward F · Headland, ALBuilt 1965 · S/N 28-2319 N81936Registered aircraftBuilt 1980 · S/N 32R-8013092 N8193NNorthstar Air LLC · Tempe, AZBuilt 1980 · S/N 32-8024021 N8193WButler Austen James · Charlotte, NCBuilt 1965 · S/N 28-2320

Back to AD 87-08-08 R3