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.

N2825KHigh Flying Club Inc · Fort Wayne, INBuilt 1979 · S/N 28R-7931212 N2825MStanton Jeffrey C · Bracey, VABuilt 1977 · S/N 28-7816313 N2825TBeatty Daniel H · Bronx, NYS/N 28R-7235122 N2826HN2826h LLC · Elizabethville, PABuilt 1979 · S/N 32-7940144 N2826TKochersberger Kevin B · Blacksburg, VABuilt 1972 · S/N 28R-7235016 N2826XAero Talons LLC · Nashville, TNS/N 32-7940145 N2826YMorgan Lewis Brian · Allen, TXS/N 32-7940146 N2828UWolf River Aviation LLC · Memphis, TNBuilt 1979 · S/N 28-7911192 N2829TSeal Dennis J · Dallas, TXS/N 28-7225243 N2829URc Dakota Aviation LLC · Denville, NJBuilt 1979 · S/N 28-7911194 N282BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2016 · S/N 2842418 N282BLBlue Line Aviation LLC · Winter Haven, FLBuilt 2023 · S/N 2881674 N282DXPiper Aircraft Inc · Vero Beach, FLS/N 28010106 N282HGCompass Rose 2 LLC · Austin, TXBuilt 1995 · S/N 2842007 N282HPSale Reported · OxonSale reportedBuilt 2000 · S/N 2843354 N282MBMitchell Larry N · Fredericksburg, TXBuilt 2000 · S/N 2843366 N282MKAlpe Holding LLC · Van Nuys, CABuilt 2003 · S/N 2842188 N282NDMoore Aviation Inc · Beaver Falls, PABuilt 2000 · S/N 2844024 N2830JPagano Nathan J · New Haven, CTBuilt 1979 · S/N 28-7916456 N2830TThree Zero Tango Corporation · Wentzville, MOBuilt 1972 · S/N 28-7205229 N2831TMesiemore Roger · Lake Wylie, SCBuilt 1972 · S/N 28R-7235141 N2832MCronin Terrance F · Federal Way, WABuilt 1977 · S/N 28-7816316 N2832TKirtland Air Force Base Aero Club · Kirtland Afb, NMBuilt 1972 · S/N 28R-7235142 N2833DScott Glen H · Spring, TXBuilt 1979 · S/N 28-7916451 N2833FWeaver Arnold G · Sandusky, MIBuilt 1979 · S/N 28-7916452 N2833NLansing Community College · Mason, MIBuilt 1979 · S/N 28-7916453 N2833SJohanson Lawrence Gco Trustee · Mckinleyville, CAS/N 28-7916458 N2834BSager Arthur · Joseph, ORBuilt 1979 · S/N 28-7990477 N2834TCrosswire Networks & Camera Systems Inc · Tampa, FLS/N 28-7990478 N2835MWth Aviation Services LLC · Scott City, KSBuilt 1977 · S/N 28-7890271 N2835NDelsair Inc · Maitland, FLBuilt 1979 · S/N 28R-7931216 N2835TFitzpatrick Robert M · Fredericksburg, TXBuilt 1979 · S/N 28-7911196 N28360Albert Lea Airport Inc · Albert Lea, MNBuilt 1979 · S/N 28-7916403 N28361Propell Air LLC · Deridder, LAS/N 28-7916404 N2836GRed Rock Fly LLC · Lewes, DEBuilt 1979 · S/N 28-7916459 N2836NGreat Planes Aviation Inc · Rochester, MNBuilt 1979 · S/N 28-7916461 N2836TRegistered aircraftBuilt 1972 · S/N 28-7225245 N2837AGreen Tree Aviation LLC · Provo, UTBuilt 1979 · S/N 28-7921050 N2837ELincoln Bruce · Lake Odessa, MIBuilt 1979 · S/N 28-7921052 N2837THuffman Jacob M III · Burleson, TXBuilt 1972 · S/N 28-7225246 N2837UCamous Alain E · Sunrise, FLS/N 28R-7918166 N28381Hanscom Aero Club · Hanscom Afb, MABuilt 1979 · S/N 28-7916408 N2838DHis Promise Aviation Service Inc · Big Spring, TXBuilt 1979 · S/N 28-7916463 N2838FGordon Brennan L · Houston, TXBuilt 1979 · S/N 28-7916464 N2839BGartman Henry L Sr · Moberly, MOBuilt 1979 · S/N 28-7990485 N2839YTurbo Arrow LLC · Fresno, CABuilt 1979 · S/N 28R-7931218 N283BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2016 · S/N 2842419 N283BLWingsleasing LLC · Wichita, KSBuilt 2023 · S/N 2881675 N283DXPiper Aircraft Inc · Vero Beach, FLS/N 28010107 N283HGCompas Rose 3 LLC · Corinth, TXBuilt 1995 · S/N 2842008

Back to AD 87-08-08 R3