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.

N4147TChandler Air Service Inc · Chandler, AZBuilt 1999 · S/N 2843272 N4147WRalls Michael Todd · Crawfordsville, IABuilt 1967 · S/N 32-40217 N41480Tradewind Aviation Co Inc · Blue Bell, PABuilt 1999 · S/N 3246147 N41482Cannella Ingrid D · Pineville, LABuilt 1974 · S/N 28-7415231 N41487Skywest Leasing Inc · St George, UTBuilt 1998 · S/N 2843179 N4148DSkywest Leasing Inc · St George, UTBuilt 1998 · S/N 2843170 N4148LFour 8 Lima LLC · Edgerton, OHS/N 3257084 N4148VUniversity Of Illinois · Savoy, ILBuilt 1998 · S/N 2843178 N41492Charter Air Travel LLC · Mount Pleasant, SCBuilt 1999 · S/N 3257105 N41497Bagley Russell L · Frankston, TXBuilt 1974 · S/N 28-7425249 N41498G&M Aircraft Inc · Wheat Ridge, COBuilt 1974 · S/N 28-7415237 N4149ABoard Of Trustees · Savoy, ILBuilt 1998 · S/N 2843189 N4149CBoard Of Trustees · Savoy, ILBuilt 1998 · S/N 2843190 N4149GBoard Of Trustees · Savoy, ILBuilt 1998 · S/N 2843191 N4149JElko Aviation Group LLC · Elko, NVBuilt 1966 · S/N 28-22474 N4149TCrosswinds Flying Club Inc · Bloomington, ILBuilt 1998 · S/N 2843192 N414BCRoche Robert C · Casa Grande, AZBuilt 1965 · S/N 28-21129 N414FLRk Aviation LLC · Nashville, INS/N 28-7125192 N414VTSnellmeyer Aviation LLC · Murrieta, CABuilt 1977 · S/N 28R-7737104 N414WMChristiansen Aviation LLC · Wilmington, DEBuilt 2004 · S/N 2844110 N41507Welty William Craig Trustee · Palm Springs, CABuilt 1974 · S/N 28-7415241 N41509Jw Rew Aviation LLC · Wilmington, DES/N 28-7415242 N4150WMathews Brandon · Eunice, NMS/N 32-40221 N41512Billingsley Randall F · North Platte, NEBuilt 1974 · S/N 28R-7435193 N41519Moloney Phillip M · Lexington, KYS/N 28-7415246 N4151PDaman Arthur C Trustee · Arroyo Grande, CABuilt 2000 · S/N 3257188 N4151RMartin Michael T · Las Vegas, NVBuilt 1968 · S/N 32-40465 N41520Heess Brandon L · Encinitas, CABuilt 1974 · S/N 28R-7435162 N41522Senecal David R · Lawrenceville, GABuilt 1974 · S/N 28-7415249 N41523Able Kenneth Charles · Concord, NCBuilt 1974 · S/N 28-7415250 N4152JPaulson Kim A · Devils Lake, NDBuilt 1966 · S/N 28-22478 N4152RRoby Richard J · Columbia, MDFirst renewal noticeBuilt 2000 · S/N 3246179 N41533Braden Aviation LLC · Easton, PABuilt 1974 · S/N 28-7415254 N41535Mjh Aviation Inc · Houston, TXS/N 28-7415256 N41537Lenko Mark A · Lovettsville, VABuilt 1974 · S/N 28-7405115 N41539Johnson Mark D · Debary, FLBuilt 1974 · S/N 28-7415259 N41540Metro Aircraft Inc · Bloomington, MNBuilt 1974 · S/N 28-7415260 N41542Brolan Aviation LLC · Kansas City, MOBuilt 1974 · S/N 28-7415262 N41545Faulks Carson · Wellington, TXS/N 32-7440097 N41547Markin Erik · Starkville, MSBuilt 1974 · S/N 28-7415263 N41548Ravotti Air LLC · Leechburg, PABuilt 1974 · S/N 28-7415264 N4154JSzabo Christopher M III · Sprakers, NYBuilt 1966 · S/N 28-22480 N4154Q770 Cfi Services LLC · Middletown, DES/N 28-7715285 N41550Wicks Matthew D · Chester, MTBuilt 1974 · S/N 28-7415266 N41554Flyboys Flight Centers LLC · Griffin, GABuilt 1974 · S/N 28-7425259 N41555Oleary John J III · Corpus Christi, TXS/N 28R-8031031 N41558Amundson Eric E · Humboldt, IAS/N 28-7415270 N4155GBaker Aviation LLC · Fort Worth, TXBuilt 1989 · S/N 2837017 N4155JCaton John F · Redlands, CAS/N 28-22751 N41570Watters James A · Dwight, ILBuilt 1974 · S/N 28-7405120

Back to AD 87-08-08 R3