Skip to content

Registered aircraft · 22,416

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.

N8998NHangar Cc5 LLC · Gainesville, GABuilt 1969 · S/N 32-40881 N8999WEagle Air LLC · Red Bud, ILBuilt 1966 · S/N 28-10817 N899DWValiair Lc Trustee · Casper, WYBuilt 1984 · S/N 28R-8431011 N899JBInvestors Trust Co Trustee · Duncan, OKBuilt 1979 · S/N 32-7940241 N899WWShelter Roofing LLC · Pascagoula, MSS/N 28-11243 N89BSHalbert Consulting LLC · Enoree, SCBuilt 1979 · S/N 32-7940199 N89BYLickteig David Leo Trustee · Ellensburg, WABuilt 1988 · S/N 2890102 N89CHLong Point LLC · Gardner, MABuilt 1979 · S/N 28-8011010 N89DTBudge Joseph H · Annapolis, MDBuilt 1988 · S/N 32-06043 N89HHStrissel Christopher A · Hilton Head Island, SCBuilt 1971 · S/N 28R-7135225 N89MJAustin Dallas V · Lillington, NCS/N 32R-7780276 N89SPSky'S The Limit Flying Club Inc · Findlay, OHBuilt 1976 · S/N 28R-7635218 N89VGSky Kings Aviation LLC · Missoula, MTBuilt 1978 · S/N 32R-7885112 N89YBGnoss Field Flying Club · Fairfax, CAS/N 28-1553 N8BBBrown Mickey Gene · Hannah, NDBuilt 1968 · S/N 28-11159 N8CNDominguez Jake R · Menifee, CABuilt 1966 · S/N 28-22301 N8ERJcr Aviation LLC · Rock Hill, SCBuilt 1966 · S/N 28-3307 N8FNValiair Ltd Co Trustee · Casper, WYBuilt 1978 · S/N 28R-7837272 N8HCRocha Adrian M · Rosharon, TXBuilt 1966 · S/N 28-10760 N8HNSol Property Group LLC · Rosenberg, TXBuilt 1975 · S/N 28R-7535277 N8MLCarlson Chad E · Downers Grove, ILBuilt 1972 · S/N 28-7205259 N8NYTap Family Corp · Wilmington, DEBuilt 2002 · S/N 3257270 N8PT10wg LLC · Newman Lake, WABuilt 1973 · S/N 32-7440024 N8PVSource International Inc · CouternonS/N 32R-7985101 N8RGGrimes Raymond L Trustee · Los Alamitos, CABuilt 1979 · S/N 32R-8029012 N8ZBEastern Nevada Aviation LLC · Gardnerville, NVBuilt 1997 · S/N 3257011 N8ZWMccarthy Edward D · New Milford, CTBuilt 1965 · S/N 28-2474 N9000MSaipan Transportation Management Solutions Inc · Saipan, MPBuilt 1971 · S/N 32-7240053 N9001JZuckerman Kenneth · Grass Valley, CABuilt 1966 · S/N 28-3026 N9001WRegistered aircraftBuilt 1964 · S/N 28-10582 N9002FRegistration Pending · Augusta, KSRegistration pendingS/N 28-7715297 N9003FStack Steven E · Santa Clarita, CABuilt 1976 · S/N 28-7790273 N9003JBlack David · Lakeville, MNBuilt 1966 · S/N 28-3028 N9003WWard John G · Palm City, FLBuilt 1964 · S/N 28-10584 N9004JRegistration Pending · Los Angeles, CARegistration pending, canceledBuilt 1966 · S/N 28-3029 N9005JSmolen Timothy R · Mckinney, TXBuilt 1966 · S/N 28-3030 N90064Annville Flight Club Inc · Hershey, PABuilt 1968 · S/N 28-11203 N9006FSeasky27 Productions LLC · Forked River, NJBuilt 1976 · S/N 32R-7780121 N9007WHart Robert D · The Villages, FLS/N 28-10588 N9009JJohnson Kent Paul · St George, UTBuilt 1966 · S/N 28-3035 N9009WMcconnell Julia · Palm Beach Gardens, FLBuilt 1965 · S/N 28-10591 N900CLThomasson Glen P · Clinton, NCBuilt 1979 · S/N 32-7940070 N900FYBain Jeffrey R · Roseville, CAS/N 28-7525252 N900JLRed Baron LLC · Pooler, GAS/N 32R-7680181 N900PHSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 28R-30302 N900SDSpot Aviation Ltd LLC · Wilmington, DES/N 32R-8013072 N900WDPotter Sherrie L · Temple, TXBuilt 1976 · S/N 28-7615282 N9010JNix Terry W · Golden, MSBuilt 1966 · S/N 28-3036 N9010WThibodeaux David J · Anna, TXS/N 28-10592 N9011CParios Vasilios · Northfield, MAS/N 28R-7803243

Back to AD 87-08-08 R3