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.

N2153NEagle Air US Inc · Eau Claire, WIBuilt 1979 · S/N 32R-7987096 N2153TFit Services LLC · Gladwin, MIBuilt 1971 · S/N 28-7205003 N2154EOtto Sheldon · Scottsdale, AZBuilt 1978 · S/N 32R-7985038 N2154FGentile Nicholas J · Spring Grove, PABuilt 1978 · S/N 28-7990203 N2154RSydenstricker Gregg Scott · Toughkenamon, PABuilt 1969 · S/N 28-5472 N2155HHarlan Eric E · Columbus, MSBuilt 1978 · S/N 32-7940016 N2155MMchatton Dret A · Redding, CABuilt 1977 · S/N 28R-7803111 N2155TFeltmeyer Rita Suzanne · Foley, ALBuilt 1971 · S/N 28-7205005 N2155UMetro Sky Aviation LLC · Valley Stream, NYS/N 28R-7931099 N21567Glance John A · Acton, CABuilt 1979 · S/N 28-7911161 N2156EMaarouf Dan H · Taylor Village, TXBuilt 1978 · S/N 32R-7987062 N2156TJacksonville Navy Flying Club · Jacksonville, FLBuilt 1971 · S/N 28-7205006 N2157BMesheryakov Roman · Jacksonville, FLBuilt 1978 · S/N 28-7916113 N2157FRineer Daryl · Pequea, PABuilt 1978 · S/N 28-7911057 N2157MTrejo Haitlay · Socorro, TXBuilt 1979 · S/N 28R-7931042 N2157NC A R S Sales Inc · Denver, NCBuilt 1979 · S/N 32R-7987097 N2157YRegistration Pending · Northampton, MARegistration pendingBuilt 1979 · S/N 28-7990376 N2158FCampbell Barrett Hunter · San Antonio, TXBuilt 1978 · S/N 32-7940005 N2158MLariscey Larry · Graniteville, SCS/N 32-7840040 N2158VDe Sousa Jorge Norberto Freitas · Cape Coral, FLBuilt 1978 · S/N 28R-7803151 N2158ZTribute Aero LLC · Rochester, MIBuilt 1979 · S/N 28-7990403 N2159HBeverly Flight Center LLC · Middleton, MABuilt 1978 · S/N 28-7916192 N2159QWisconsin Aviation-Four Lakes Inc · Madison, WIBuilt 1979 · S/N 28-7916282 N215CTahome LLC · Saint Petersburg, FLS/N 32501 N215JDShapiro Jonathan · New York, NYBuilt 1976 · S/N 32R7680241 N215RMKevin W Singletary & Associates LLC · Little River, SCBuilt 1977 · S/N 28R-7703219 N215STNapoleon Christopher D · Allegany, NYBuilt 1967 · S/N 32-891 N215UParagon Airplane Leasing Co · Fort Myers, FLBuilt 2023 · S/N 28020136 N215ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881607 N21605Chandler Air Service Inc · Chandler, AZBuilt 1978 · S/N 28-7990054 N2160THughes Johnny D · Meridian, MSS/N 28-7205010 N2161AHoyer Chase R · Jarrell, TXBuilt 1978 · S/N 32R-7985003 N2161XLake Riley Aviation Inc · Excelsior, MNBuilt 1979 · S/N 32-7940088 N2162REndthoff Wayne K · Beloit, WIBuilt 1969 · S/N 28-5474 N2162TVolantis LLC · West Fargo, NDBuilt 1971 · S/N 28-7205012 N2162XTaylor Express Investments Inc · Wilmington, DES/N 32-7940089 N2163GWilson Willard III · Cannon Falls, MNBuilt 1978 · S/N 28-7990194 N2164GAulton New Energy Inc · Monterey, CABuilt 1978 · S/N 28-7990195 N2164UWilson Darryl M · New Albany, OHBuilt 1979 · S/N 28R-7931101 N2165BCondor LLC · Cumberland, RIBuilt 1978 · S/N 28-7990122 N2165HQuin Air Inc · Shreveport, LABuilt 1978 · S/N 28-7990210 N2166BScroggs Ross A · Locust Grove, GABuilt 1978 · S/N 28-7990123 N2166FUniversity Of Oklahoma · Norman, OKBuilt 1978 · S/N 28-7916208 N2166LNefc Inc · North Andover, MABuilt 1979 · S/N 28-7990259 N2167ADelaware Valley Aviation Inc · Langhorne, PABuilt 1978 · S/N 32R-7985004 N2167KTurner Tim R · San Angelo, TXBuilt 1978 · S/N 28-7911075 N2167TKissi Ernest · New Britain, CTBuilt 1971 · S/N 28-7205017 N21683Flying H Inc · Hoxie, KSBuilt 1978 · S/N 32-7840188 N2168BBonjour Hugo E · Houston, TXBuilt 1978 · S/N 32R-7987032 N2168KLj Dakota LLC · Berkeley Heights, NJBuilt 1978 · S/N 28-7911076

Back to AD 87-08-08 R3