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.

N41954Up And Up Aviation LLC · Magnolia, TXBuilt 1974 · S/N 28-7415368 N4195WSarvis Thomas · Bullhead City, AZBuilt 1967 · S/N 32-40283 N41963Schafer Gary L · Greenwood, DEBuilt 1974 · S/N 28-7425302 N41966Wray Jimmy Don · White House, TNBuilt 1974 · S/N 28-7425303 N41967Krog Steven L · Hartford, WIBuilt 1974 · S/N 28-7415370 N41969Lazy 8 Aviation LLC · Arden, NCBuilt 1974 · S/N 28-7415371 N41973Legacy Aviation LLC · Murfreesboro, TNS/N 28-7405155 N41977Augusti Group Enterprises Inc · Clayton, NCBuilt 1974 · S/N 28-7415375 N41978Henderson Jason E · Corona, CABuilt 1974 · S/N 28-7415376 N41980Warren Donald E · Pine Bluff, ARBuilt 1974 · S/N 28-7415377 N41983Brotherman LLC · Hereford, TXBuilt 1974 · S/N 28-7415379 N41985Aerospace Systems And Training LLC · Orange City, FLBuilt 1974 · S/N 28-7405157 N4198FRal Aviation LLC · Trumbull, CTBuilt 1976 · S/N 28-7790006 N41992Stein Anthony J · Locust Grove, GABuilt 1974 · S/N 28-7415380 N41995Columbus State Community College · Columbus, OHFirst renewal noticeBuilt 1974 · S/N 28-7415382 N41997Caae Leasing LLC · Lake Zurich, ILBuilt 1974 · S/N 28R-7435235 N4199JHallenbeck Jesse · Bellingham, WAS/N 28-22543 N419CCHills Craig · Avon, INBuilt 1979 · S/N 28-7911268 N419GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881176 N419LJGowenmleah Jill · Lawrenceburg, TNBuilt 1977 · S/N 32-7840060 N419PASkywest Leasing Inc · St George, UTBuilt 2000 · S/N 2843413 N419PHTaylor Septic Services LLC · Deltona, FLBuilt 1979 · S/N 32-7940039 N419RTPriddy Francis Wayne · Alvord, TXBuilt 1978 · S/N 32R-7887059 N419SBLipscomb Brian · Fulshear, TXBuilt 1992 · S/N 2811034 N419SWSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1967 · S/N 32-40284 N419WAnn Arbor Flyers Inc · Ann Arbor, MIBuilt 1995 · S/N 2843001 N41ALMclain Aviation LLC · Lyons, GAS/N 32-7240107 N41AWWalker James A · Birmingham, ALBuilt 1966 · S/N 28-21385 N41EKPrairie View Energy II LLC · Granite Falls, MNBuilt 1978 · S/N 32R-7885096 N41GFMesmer Refrigeration Inc · Buffalo, NYBuilt 1977 · S/N 28R-7703083 N41JAJersey Aero Club · Lakewood, NJBuilt 1997 · S/N 2843081 N41KFThomas Wayne · Powell, OHBuilt 1968 · S/N 28R-30505 N41LWSeccombe Stanley G III · Concord, CAS/N 32R-8329031 N41MSJennings William K · Chandler, AZBuilt 1967 · S/N 28-22716 N41PVBear Nathan Eugene · Cove, ORBuilt 1979 · S/N 28-8016063 N41SGSunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 28R-7837288 N41WAHackler Jeanette D · Arlington, TXBuilt 1967 · S/N 28R-30211 N41ZYBailey Thomas A · Claymont, DES/N 28-3087 N4200BCondair Flyers Inc · Latham, NYBuilt 2000 · S/N 2843319 N4201JYoerg Keith W · Culver City, CAS/N 28-22545 N4201RCrockett Guy S · Louisville, KYBuilt 1968 · S/N 32-40542 N4202JParker Aviation LLC · Camdenton, MOBuilt 1966 · S/N 28-22546 N4202TSexton Ronnie K · Clarksville, ARBuilt 1971 · S/N 28-7205090 N4203RFier Michael A · Mundelein, ILBuilt 1969 · S/N 32-40568 N4204RVeal Tim S · Kenai, AKBuilt 1969 · S/N 32-40569 N4204TMorin Lucien A · San Antonio, TXBuilt 1971 · S/N 28-7210004 N4205RMarking Refrigeration Inc · Omaha, NEBuilt 1969 · S/N 32-40570 N4205TPoulsen Carlton Jr · Bossier City, LABuilt 1971 · S/N 28-7205095 N4206JRegistration Pending · Linn, MORegistration pendingBuilt 1966 · S/N 28-22551 N4206RTelevision Signal Distribution Specialists Inc · Canton, OHBuilt 1969 · S/N 32-40571

Back to AD 87-08-08 R3