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.

N2954NLewman Daniel O Jr · Summit, MSBuilt 1979 · S/N 28-7990586 N2954QClark Ronald Joe · Scottsdale, AZBuilt 1979 · S/N 28R-7918234 N2955BBiller Scott · Urbandale, IABuilt 1979 · S/N 28-7911285 N2955MRls Rental Co DBA · Joplin, MOBuilt 1977 · S/N 28-7816326 N2955QAussieyank Air LLC · Reno, NVBuilt 1979 · S/N 28-7911265 N2955RSmith Billy V · Baton Rouge, LABuilt 1979 · S/N 28-7911266 N2955TFive Five Tango LLC · Rockford, ILBuilt 1979 · S/N 28-7911267 N29566International Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N 28R-7918146 N2956AHuebner Dennis Andrew · Morgan Hill, CABuilt 1979 · S/N 28-7911269 N2956BFlorida Coatings & Waterproofing LLC · Fort Pierce, FLS/N 28-7911270 N2956CFlying The Fields LLC · Algonquin, ILBuilt 1979 · S/N 28-7911271 N2956PVann Dudley Carroll · Greenville, NCBuilt 1979 · S/N 28-7916583 N2956RFlightline LLC · Summerville, SCBuilt 1979 · S/N 28-7990588 N2957FRichardson John Daniel · Madisonville, LABuilt 1979 · S/N 28-7911273 N2957MJacobson Larry · Commack, NYBuilt 1979 · S/N 28-7911274 N2957NBak John A · Lake Forest, CABuilt 1979 · S/N 32-7940228 N2957RBantle Aviation LLC · Midlothian, VABuilt 1979 · S/N 32-7940229 N2959MHanneman Robert · Claremore, OKBuilt 1977 · S/N 28-7890281 N2959QParis Air Inc · Vero Beach, FLBuilt 1979 · S/N 28-7916585 N2959USmart5 LLC · Kissimmee, FLBuilt 1979 · S/N 28-7916588 N295BCWieler Jacob · Petty, TXS/N 28-7916435 N295DAJackson Construction LLC · Charleston, SCBuilt 1968 · S/N 28-24582 N295FSBoard Of Trustees Of Southern Illinois University · Murphysboro, ILBuilt 2018 · S/N 2844178 N295MAStanton David M Jr · Kiawah Island, SCBuilt 1995 · S/N 2811040 N295MRCarrera Air LLC · Tampa, FLBuilt 2005 · S/N 3257405 N295SRCarpenter William R · West Springfield, VABuilt 1994 · S/N 3213089 N29604Farrington John R · Cedar Park, TXBuilt 1979 · S/N 28-7911182 N2960DRed Baron Rentals LLC · Jacksonville, FLBuilt 1979 · S/N 28-7916590 N2960LLucas Danny O · Ridgeland, SCBuilt 1979 · S/N 28R-7918236 N2960RVarun 2016 LLC · Florence, SCBuilt 1979 · S/N 28-7911275 N2960YHudson Maury B · Humble, TXBuilt 1979 · S/N 32-7940230 N29610Ammar Elias G · Colton, CABuilt 1979 · S/N 28-7911183 N2961BHyldburg Aviation · Plymouth, MABuilt 1979 · S/N 28-7916591 N2961WKrauss Solutions LLC · Debary, FLBuilt 1979 · S/N 28-7916594 N29623Swann Hardy · Nacogdoches, TXBuilt 1979 · S/N 32R-7987123 N2962RHurn Enterpises LLC · Grand Beach, MIS/N 28R-35347 N2962UFlake Philip · Pearland, TXS/N 28-7916598 N2962WB&R Aircraft LLC · Wadsworth, OHBuilt 1979 · S/N 28R-7918239 N2962YGutierrez Juan · Sarasota, FLS/N 28R-7918240 N29638Seal Seismic Service LLC · Oklahoma City, OKS/N 28R-7918155 N2964CBrown A Russell · Lafayette, TNBuilt 1979 · S/N 28-7911279 N2964DKluge Kris D · Mound, MNBuilt 1979 · S/N 28-7911280 N2965APa 32 LLC · Union Center, WIBuilt 1979 · S/N 32-7940236 N2965WFly On LLC · Boise, IDBuilt 1979 · S/N 28-8090003 N2966RTobin Michael A · Plain City, OHBuilt 1969 · S/N 28R-35351 N2966YPiper Holdings LLC · Osage Beach, MOFirst renewal noticeBuilt 1979 · S/N 32R-8013003 N29677Anderson Aircraft Inc · Central City, NEBuilt 1979 · S/N 28-7911186 N2967QPowell Samuel C · Burlington, NCBuilt 1979 · S/N 32-7940243 N2968LWills Terry W · Cedar Park, TXBuilt 1979 · S/N 32R-7987125 N2969QOsullivan James S · Palo Alto, CABuilt 1977 · S/N 32-7740056

Back to AD 87-08-08 R3