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.

N2245KPfeiffer Carl A Trustee · Moline, ILBuilt 1978 · S/N 28-7916237 N2245UFarris Gregory A · Chesterfield, MOBuilt 1979 · S/N 28-7916133 N2245WDorans Aviation LLC · Yardley, PABuilt 1979 · S/N 28-7990354 N22473Miller Aviation Group LLC · Coon Rapids, MNBuilt 1978 · S/N 28-7916071 N2247ABcs Aviation LLC · Colquitt, GABuilt 1978 · S/N 32R-7887286 N2247DSky Venture Inc · Franklin, WIS/N 28-7990168 N2247KSkyline Solutions Unlimited LLC · Edgewater, FLBuilt 1978 · S/N 28-7916238 N2247MCamp Randall · Duncan, SCBuilt 1977 · S/N 28R-7837073 N2247WButts Alan R · Bismarck, NDS/N 28R-7703159 N2247XElliott James F · Florence, ALBuilt 1979 · S/N 28R-7918094 N2248D2 Wings LLC · Noblesville, INS/N 28-7990169 N2248GClear Skies Aviation 1959 LLC · Boca Raton, FLS/N 28R-7918016 N2248UNorth Central Flight Center LLC · Warwick, RIFirst renewal noticeBuilt 1979 · S/N 28-7916316 N2248XSecond Life Properties LLC · Salisbury, MDBuilt 1979 · S/N 28R-7918095 N2249KGarner William B · Argyle, TXBuilt 1978 · S/N 28-7990239 N2249NPatzer Emmons M · Palmetto, FLBuilt 1979 · S/N 28R-7931053 N2249PJrp Holdings LLC · Highland, CABuilt 1979 · S/N 28-7911105 N2249TKrause Michael B · Camarillo, CABuilt 1979 · S/N 28-7990318 N2249VMystere Flying Club Inc · Little Ferry, NJFirst renewal noticeBuilt 1979 · S/N 28-7990347 N2249XElwood Andrew D · Essex, CTBuilt 1979 · S/N 28R-7918096 N224BBHarris Sydnie Nicole Trustee · Austin, TXBuilt 1969 · S/N 28-25659 N224ELNrcme Training Systems LLC · Breese, ILBuilt 1977 · S/N 28-7716238 N224HSHenderson State University · Arkadelphia, ARBuilt 2007 · S/N 2844131 N224JBDutchman Leasing Services LLC · Richardson, TXBuilt 1975 · S/N 28-7505140 N224MMYoung David A · Bedford, TXBuilt 1972 · S/N 28-7225291 N224NDGood Flight Aviation LLC · Stockton, CABuilt 2001 · S/N 2842112 N224TBHot Wings Aviation LLC · Indianapolis, INBuilt 2023 · S/N 28020126 N224VUp And Up Aviation LLC · Magnolia, TXS/N 28-7916402 N224VWMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881533 N2250BBill Frank J · Enfield, CTBuilt 1978 · S/N 28-7916122 N2250KKaemmerling Mirna C · White Oak, TXBuilt 1978 · S/N 28-7990240 N2250XValdes Manuel · Miami Beach, FLBuilt 1979 · S/N 28R-7918097 N2251MBelfiglio Brett N · Arroyo Grande, CABuilt 1979 · S/N 28R-7931001 N2253MOgata Randy Lynn · Yuma, AZBuilt 1977 · S/N 28R-7803116 N225CBCalifornia Baptist University · Riverside, CABuilt 2023 · S/N 2881634 N225FGMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881569 N225KLMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881534 N225PACapitol Aircraft Inc · Wilmington, DEBuilt 1976 · S/N 28R-7635443 N225PKInternational Air Services Inc Trustee · Carson City, NVS/N 32R-7780086 N225RSMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881543 N225TBHot Wings Aviation LLC · Indianapolis, INBuilt 2023 · S/N 28020127 N2260MBomar Robert B · Bedford, TXBuilt 1977 · S/N 28-7816264 N2261QAndrews University · Berrien Springs, MIBuilt 1977 · S/N 28-7790386 N2262FAnchor Aviation LLC · Blue Bell, PABuilt 1978 · S/N 28-7990074 N2262MAg Air Squadron Two LLC · Saint Joseph, ILBuilt 1977 · S/N 28-7816265 N2262QFirst Choice Insurance Partners LLC · Williamston, NCBuilt 1977 · S/N 28-7790387 N2263QRoss Air Chicago LLC · Chicago, ILBuilt 1977 · S/N 28R-7737030 N2264MArcher Aviation LLC · Orrtanna, PABuilt 1978 · S/N 28-7890237 N2264TTofik Mahir · Cumming, GAS/N 28-7125527 N2265MEik Baaz LLC · Rocklin, CABuilt 1977 · S/N 28-7890238

Back to AD 87-08-08 R3