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.

N8542NSchwechten Kevin · New Waverly, TXBuilt 1969 · S/N 28-11341 N8542WChenevert Kenneth F · Seguin, TXBuilt 1963 · S/N 28-10043 N8543EAce Aircraft Leasing Inc · Nazareth, PABuilt 1976 · S/N 28-7625140 N8544NWalton Joseph B · Arlington, TNBuilt 1969 · S/N 28-11343 N8544WTyler Brian W · San Gabriel, CAS/N 28-10045 N8545NMatheny Robert S Jr · Beaufort, NCBuilt 1969 · S/N 28-11344 N8546FBarts Flying Service Inc · Storm Lake, IABuilt 1976 · S/N 32R-7780109 N8546NBeaver Brook Aviation LLC · Scotia, NYBuilt 1969 · S/N 28-11345 N8546WNowos Monica Leigh · Rochester Hills, MIBuilt 1963 · S/N 28-10047 N8549CN8549c LLC · Mesa, AZBuilt 1976 · S/N 287610078 N8549NDowning Ray E III · Topeka, KSBuilt 1969 · S/N 28-11348 N8549WAllstead Bradley E · Trenton, MIBuilt 1963 · S/N 28-10061 N854CAJunie The Flying Dog LLC · Atlanta, GABuilt 1973 · S/N 28-7415040 N854PUTrustees Of Purdue University · West Lafayette, INS/N 2881327 N854VLBlue Waters Air Charters LLC · San Juan, PRBuilt 1974 · S/N 32-7500010 N8550WRegistration Pending · Nampa, IDRegistration pendingBuilt 1963 · S/N 28-10062 N8551NRegistered aircraftBuilt 1969 · S/N 28-11350 N8551WDaideo Enterprises LLC · Slingerlands, NYBuilt 1963 · S/N 28-10063 N8555WSottile Andre M · Monroe, MIBuilt 1963 · S/N 28-10069 N8556WBeans And Cool Dude LLC · Denton, TXBuilt 1963 · S/N 28-10070 N8558WEmerson Scott D · Roseville, CABuilt 1963 · S/N 28-10072 N8559NJohnson Arnold R · Mina, SDBuilt 1969 · S/N 28-11357 N8559WKelcher Colton C · Olympia, WABuilt 1963 · S/N 28-10073 N855PUTrustees Of Purdue University · West Lafayette, INS/N 2881328 N8560WSafrit Christopher · Midlothian, TXBuilt 1963 · S/N 28-10053 N8561NPorter Louisa · San Diego, CABuilt 1970 · S/N 28-11359 N8561WMarble William R · Sparks, NVBuilt 1963 · S/N 28-10059 N8562NLorox Llp · Wishek, NDBuilt 1970 · S/N 28-11360 N8563WRoche Daniel · Bellefonte, PABuilt 1963 · S/N 28-10075 N8564FRmi Air LLC · Ocilla, GABuilt 1976 · S/N 28-7715282 N8564NEby Leo V · Clearville, PAS/N 28R-7135112 N8564WBinns George E · Hackettstown, NJBuilt 1963 · S/N 28-10076 N8566NN8566n LLC · Briarwood, NYBuilt 1970 · S/N 28-11363 N8567NWeekend Aviators Ltd · Herndon, VABuilt 1970 · S/N 28-11365 N8567WNielsen Peter K · Bellingham, WABuilt 1963 · S/N 28-10079 N8569QSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842404 N8569WColumbia Gorge Community College · The Dalles, ORBuilt 1963 · S/N 28-10081 N856PProfessional Training Aircraft LLC · Wilmington, DEBuilt 2018 · S/N 2843944 N856PUTrustees Of Purdue University · West Lafayette, INS/N 2881329 N856RCN856rc LLC · Bow, WABuilt 1980 · S/N 32-8024003 N856SCWooten Patricia · Avinger, TXBuilt 1978 · S/N 32R-7985059 N8570FIxi LLC · West Bloomfield, MIBuilt 1976 · S/N 28-7790258 N8570RSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842405 N8571NSeverance Douglas E · Danville, CABuilt 1970 · S/N 28-11367 N8571YSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842406 N8572WKoopmans Caleb · Bridgewater, SDBuilt 1963 · S/N 28-10084 N8572ZSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842407 N8573JSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842408 N8573WRenner Paul Eric · Parkville, MOBuilt 1963 · S/N 28-10085 N8574KSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842409

Back to AD 87-08-08 R3