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.

N7849NZdravko Tyrone · Clearwater, FLBuilt 1969 · S/N 28-5305 N784ASDe Paola Humerto J · Pembroke Pines, FLBuilt 1972 · S/N 28R-7235160 N784LAN784la LLC · Philadelphia, PABuilt 2025 · S/N 28020216 N7850NMach 3 LLC · Enid, OKBuilt 1969 · S/N 28-5306 N7851NWilson Steven Alfred Trustee · Runnells, IABuilt 1969 · S/N 28-5307 N7851WJl Wings LLC · Prosper, TXBuilt 1964 · S/N 28-1870 N7852NDelatte Joseph S · Gonzales, LABuilt 1969 · S/N 28-5309 N7852WSouthall David S · Poquoson, VABuilt 1964 · S/N 28-1871 N7853CDue West Aviation LLC · Brandon, SDBuilt 1975 · S/N 28-7690086 N7853NLong Nels B · Caledonia, OHBuilt 1969 · S/N 28-5310 N7854JMilstead Eric N · Tampa, FLBuilt 1966 · S/N 28-3736 N7855SCse Aviation LLC · Plymouth, MABuilt 1975 · S/N 28-7515331 N7856N56 November LLC · Brighton, COBuilt 1969 · S/N 28-5313 N7856WN7856w LLC · Shelocta, PABuilt 1964 · S/N 28-1876 N7857FGeorge William Jesse · Alamogordo, NMBuilt 1976 · S/N 32R-7780084 N7857NKranz Charles Leroy · Milbank, SDS/N 28-5314 N7857WAllen Aviation LLC · Spring Hill, KSBuilt 1964 · S/N 28-1878 N7858WBeans Steven T · Cozad, NEBuilt 1964 · S/N 28-1879 N7859NNls Real Estate LLC · Irving, TXBuilt 1969 · S/N 28-5317 N785LAN785la LLC · Philadelphia, PABuilt 2025 · S/N 28020217 N785RMJesnet Aviation LLC · Sanford, FLBuilt 1986 · S/N 28-8616057 N7860NLindsay Construction LLC · Fernandina Beach, FLBuilt 1968 · S/N 28-5318 N7860WRed Rock Flying School LLC · Mesa, AZBuilt 1964 · S/N 28-1881 N7861WComer Christopher C · Randleman, NCBuilt 1964 · S/N 28-1882 N7862NMontero Joseph A · Spring Hill, FLBuilt 1969 · S/N 28-5319 N7863WBauer Thomas M · Fairfield, PABuilt 1964 · S/N 28-1884 N7865NWalkup Gerald L · Novato, CABuilt 1969 · S/N 28-5322 N7866WWiger Theodore L · Falcon Heights, MNBuilt 1964 · S/N 28-1887 N7867WGilmore John J · San Carlos, CABuilt 1964 · S/N 28-1888 N7868FC & R Aero Inc · Marco Island, FLBuilt 1976 · S/N 32R-7780085 N7869WLichtenstein James E · San Carlos, CABuilt 1964 · S/N 28-1891 N786BGGross Kyle F · Salt Lake City, UTBuilt 2006 · S/N 2844126 N786DJDgj Tex LLC DBA · Cleburne, TXS/N 28-7415358 N786FBEagle Aviation LLC · Indianapolis, INBuilt 2024 · S/N 28020176 N786MBSkys Edge Aviation LLC · Midland, TXBuilt 1964 · S/N 28-2106 N7870WGaydon Jesse A · Sharpsburg, GABuilt 1964 · S/N 28-1892 N7871WWisdom Gary A · Farmersville, TXBuilt 1964 · S/N 28-1893 N7872WHeard Derrick A · Greensboro, NCBuilt 1964 · S/N 28-1894 N7874WLink John P · West Milford, NJBuilt 1964 · S/N 28-1898 N7877WShields John R · Chester, NHBuilt 1964 · S/N 28-1901 N7879WFlyhome One LLC · Chandler, AZBuilt 1964 · S/N 28-1903 N787ARLeung Ka Hung · Apple Valley, CABuilt 1980 · S/N 32R-8029083 N787BGWestchester Flying Club Inc · Purchase, NYBuilt 2002 · S/N 2844085 N787BRNaron Robert W · Poolville, TXBuilt 1965 · S/N 28-2091 N787CESouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 28-43336 N787CJInternational Air Services Inc Trustee · Carson City, NVBuilt 2010 · S/N 2843679 N787DJDgj Tex LLC DBA · Cleburne, TXBuilt 1977 · S/N 28-7816014 N787FBHot Wings Aviation LLC · Fishers, INBuilt 2025 · S/N 28020210 N787NDUnd Aerospace Foundation · Grand Forks, NDS/N 2881306 N787RPSilver Fox Aircraft LLC · Queen Creek, AZBuilt 1985 · S/N 28-8690025

Back to AD 87-08-08 R3