Skip to content

Registered aircraft · 72,007

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-10-06-R1') 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-10-06-R1') 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-10-06-R1')
    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-10-06-R1')
  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-10-06-R1')
  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-10-06-R1')
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.

N347BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2023 · S/N 2881652 N347CBMishock Kevin A · Melbourne, FLBuilt 1976 · S/N 32R-7780002 N347CHAce Flight Center · St Thomas, VIBuilt 1974 · S/N 17263661 N347DProfessional Training Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 2843840 N347DMSpivey Ricky S · Samson, ALBuilt 1997 · S/N 21803 N347DWSnoopy Air LLC · Branch, LABuilt 1996 · S/N 4636059 N347ECallahan Kevin Michael · Des Moines, WABuilt 2011 · S/N 72189 N347GDNye Brian M · Independence, ORBuilt 2002 · S/N 23851 N347GWAllen Air LLC · Creola, ALBuilt 1966 · S/N 28-3651 N347JPPhantom Flyer LLC · Yelm, WABuilt 2003 · S/N 347 N347MKNorth Star Aviation · Mankato, MNBuilt 2020 · S/N 2881417 N347RAAdamson Matthew C · Sherwood, ARBuilt 1978 · S/N 3100 N347RPRegistration Pending · Daytona Beach, FLRegistration pending, canceledS/N 28-571 N347STGraber Joel C · Collins, MSBuilt 2015 · S/N 0001 N347WGMt Aircraft LLC · Port Orange, FLBuilt 1968 · S/N 17256883 N34808Barber Jeffrey A · Blaine, MNBuilt 1973 · S/N 17702016 N34809Grassmyer Richard M · Salem, INBuilt 1973 · S/N 17702017 N3480K3480k LLC · Waycross, GABuilt 1967 · S/N 28-23575 N3480TMoffatt Thomas O Jr · Diberville, MSBuilt 1968 · S/N 17700780 N3480XLorenzi Mark E · Lancaster, OHBuilt 1966 · S/N 1154 N34813Max Gs LLC · Wilmington, DEBuilt 1973 · S/N 17702020 N34816Clark Tal O · Hudson, COBuilt 1973 · S/N 17702022 N34818Rosenberger Mark W · West Columbia, SCBuilt 1973 · S/N 17702023 N3481TEstes Kenneth · Portland, ORS/N 17700781 N3481WSandpiper Air LLC · Charles Town, WVBuilt 1966 · S/N 32-358 N3481XN3481x LLC · Reno, NVBuilt 1966 · S/N 3421 N34821Gibbs Keith L · Eaton Rapids, MIBuilt 1973 · S/N 17702025 N34823Eight Twenty Three LLC · Santa Barbara, CABuilt 1973 · S/N 17702026 N34829Woods Roderick D · Collierville, TNBuilt 1974 · S/N 17702029 N3482THaskell Thomas Edward · Georgetown, TXBuilt 1968 · S/N 17700782 N3482XCollins Dallas · Columbia, SCBuilt 1966 · S/N 3422 N34830Airworx LLC · Gotha, FLBuilt 1973 · S/N 17702030 N34833Dallman Bruce D · Terre Haute, INBuilt 1973 · S/N 17702032 N34835Saddleback Enterprises LLC · Newport Beach, CABuilt 1973 · S/N 17702033 N3483TCalhoun Edward J · Whitney, NEBuilt 1968 · S/N 17700783 N3483WSale Reported · Lubbock, TXSale reportedBuilt 1966 · S/N 32-361 N3483XDoddy Del · Cincinnati, OHS/N 1155 N34845Ccf Ventures Inc · Bangor, MES/N 17702039 N34847Hanna David G · Imperial, NEBuilt 1973 · S/N 17702041 N3484MNiner One Aviation LLC · Hillsboro, ORBuilt 1947 · S/N 12-2080 N3484NPietsch Warren A · Minot, NDBuilt 1967 · S/N 680067 N3484TCairo Jane LLC · Ponca City, OKBuilt 1968 · S/N 17700784 N34850Axs Sourcing It LLC · Chugiak, AKBuilt 1973 · S/N 17702044 N34852Pride Electric Enterprises · Prescott Valley, AZBuilt 1973 · S/N 17702046 N34858Schmid Walter Allen · Fruitland, IDFirst renewal noticeBuilt 1973 · S/N 17702049 N3485WKemp James A · Deland, FLBuilt 1966 · S/N 32-363 N3485XCdm Flight Club Inc · La Jolla, CABuilt 1966 · S/N 1157 N3485ZVarco John M · Palmer, AKBuilt 1960 · S/N 18-7317 N34860Pittman Charles R Trustee · Waterloo, ILBuilt 1973 · S/N 17702051 N34865Schmedeman Andrew J · Sanford, FLBuilt 1973 · S/N 17702053

Back to AD 87-10-06 R1