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.

N4510FWiest Donald J · Le Sueur, MNBuilt 1976 · S/N 28-7790036 N4510RMcmichael Steven G · Eden, NCBuilt 1979 · S/N 28-8090036 N45110Bluebeck Ltd · East Norwich, NYBuilt 1979 · S/N 28-7911294 N4511BGcbc LLC · Norman, OKBuilt 1979 · S/N 28-8090037 N4511FLewis Brett · Madison, NJBuilt 1976 · S/N 28-7790037 N4511JNoyes Tony · Lewisville, TXS/N 28R-30367 N4511NOliver Stephen F · Spring Branch, TXBuilt 1979 · S/N 28R-7918248 N4511SConner Gary Dean · Cypress, TXBuilt 1979 · S/N 28R-7931287 N4511VOraz Aviation LLC · Oregon City, ORBuilt 1979 · S/N 28-7911293 N4512FChase David B Trustee · Danville, CABuilt 1976 · S/N 28-7790038 N4512LA&J Aircraft Leasing Inc · Burlington, COS/N 28-8016016 N4512RElder Abuse Air Force · Rcho Sta Marg, CAS/N 28-21213 N4512XSullivan Bradley · Tomball, TXBuilt 1975 · S/N 28-7625047 N4513DRkm Aviation LLC · Lexington, NCBuilt 1979 · S/N 28-8090038 N4513FDeripaska Gary Stanley · Owasso, OKBuilt 1976 · S/N 28R-7635413 N4513JMalone Ronald · Englewood, TNBuilt 1968 · S/N 28R-30370 N4513QBobcat Aviation LLC · Northfield, MNBuilt 1977 · S/N 32-7740066 N4513RRegistration Pending · Fort Worth, TXRegistration pendingBuilt 1965 · S/N 28-21214 N4514JTrinity Aviation Ltd · Wilmington, DEFirst renewal noticeBuilt 1968 · S/N 28R-30371 N4515FEfficient Air Travel LLC · Bel Air, MDBuilt 1976 · S/N 32R-7680456 N4516JFly By Nite Aviation LLC · Tampa, FLBuilt 1968 · S/N 28R-30373 N4516QExcessive Adventures LLC · Palm City, FLS/N 32R-7780331 N4516XMckown Martin H · Ocean City, MDBuilt 1975 · S/N 28R-7635068 N4517RGilbert Zachary · Jekyll Island, GAS/N 28-21218 N4517TTate Levi W · Saint George, UTBuilt 1972 · S/N 28-7205177 N4518JFaizanali Hashme I · Middletown, OHBuilt 1968 · S/N 28R-30375 N4518REdmondson William A · Rosamond, CAFirst renewal noticeBuilt 1965 · S/N 28-21220 N4518TBnr Aviation LLC · Lawrenceville, GABuilt 1972 · S/N 32-7200022 N451BTNeosho Investments LLC · Neosho, MOBuilt 1967 · S/N 28-23951 N451JSend North · Anchorage, AKBuilt 1965 · S/N 32-254 N451NKSink Craig S · Queen Creek, AZBuilt 1973 · S/N 327340027 N451TWYale Companies LLC DBA · Indianapolis, INBuilt 2023 · S/N 28020140 N451XCross Winds Flying Club Inc · Bloomington, ILBuilt 1979 · S/N 28-7911129 N4520JRegistered aircraftBuilt 1968 · S/N 28R-30377 N4520QShumate Jeff · Park City, UTS/N 28-7725237 N4520RBurge John A · Pensacola, FLS/N 28-21222 N4520TBrummell Colten Andrew · Hannibal, MOBuilt 1971 · S/N 28-7105216 N4521JSpringer Louis A · Bellflower, CAS/N 28R-30378 N4521RLenz Gregory K · Everton, MOBuilt 1965 · S/N 28-21223 N4521TSpencer Kevin L DBA · Bend, ORBuilt 1972 · S/N 28R-7235077 N4521XClemmons Philip B · Madison, ALBuilt 1975 · S/N 28-7615023 N4522XBlack Rain Inc · Wilmington, DES/N 28-7690028 N4523JN4523j LLC · Wilmington, DEBuilt 1968 · S/N 28R-30381 N4523RGardner Michael J · Ashland, ILS/N 28-21225 N4524FLwg Archer LLC · Reading, PABuilt 1976 · S/N 28-7790039 N4524XSharp Jacob · El Paso, TXBuilt 1975 · S/N 28R-7635069 N4525RFreiberg Industries Inc · State Center, IAFirst renewal noticeBuilt 1965 · S/N 28-21228 N4526FReabe Spraying Service Inc · Plover, WIBuilt 1976 · S/N 28-7790040 N4526JMcallister Aviation LLC · Richmond Hill, GABuilt 1968 · S/N 28R-30384 N4526RGulledge Richard · Deland, FLBuilt 1965 · S/N 28-21229

Back to AD 87-08-08 R3