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.

N4526TBoal Ronald O · Mooresburg, TNBuilt 1972 · S/N 28R-7235078 N4526XGeorge Barbara A · Carlisle, PABuilt 1975 · S/N 28-7625049 N4527JRegistration Pending · Cedar Hill, TXRegistration pendingS/N 28R-30385 N4527RGmk Aviation LLC · Brighton, MIBuilt 1965 · S/N 28-21230 N4528FPhoenix Aviation Solutions LLC · Clarksville, TNBuilt 1976 · S/N 28R-7635414 N4528RPhilbrick William E · Virginia Beach, VABuilt 1965 · S/N 28-21231 N4528XChandler Agricultural Ind LLC Series Avation · Montgomery, ALBuilt 1975 · S/N 28-7690030 N4529RSulzby Ivan Gerardo · Las Vegas, NVBuilt 1965 · S/N 28-21232 N452PWDaniella Levi & Associates Pc · Fresh Meadows, NYBuilt 2004 · S/N 3246226 N4530TKoprivnik Anton J · Painesville, OHS/N 287225181 N4531FOneill Robert J · Rocklin, CABuilt 1976 · S/N 28R-7635415 N4531JQualitair LLC Trustee · MichelstadtBuilt 1968 · S/N 28R-30389 N4532JCohen Kyle Lee · Houston, TXBuilt 1968 · S/N 28R-30390 N4532RWherley Matthew J · Plato, MNBuilt 1965 · S/N 28-21236 N4532XMarrs Daniel J · Red Wing, MNBuilt 1975 · S/N 28-7615025 N4533XSale Reported · Crystal, MNSale reported, pending cancellationBuilt 1975 · S/N 28-7690031 N4534JCartaya Lazaro C · Miami, FLS/N 28R-30393 N4534RDuwelius Charlotte Sue DBA · Hermiston, ORBuilt 1965 · S/N 28-21238 N4534X4534xray Flyers Ltd · Lima, OHBuilt 1975 · S/N 28R-7635071 N4535JMooney Executive Partnership · Kent, WABuilt 1968 · S/N 28R-30394 N4535TCrews Joseph G · Cleveland, MSBuilt 1971 · S/N 28-7105222 N4536JSale Reported · Merrill, WISale reportedBuilt 1968 · S/N 28R-30395 N4536RRoesler Robert D · Gordonsville, VABuilt 1965 · S/N 28-21240 N4537FJohnson Justin · Ashland, ORBuilt 1976 · S/N 32R-7680458 N4537TRussell Brice S · Milton, MABuilt 1971 · S/N 28-7105229 N4538QFlying V LLC · West Berlin, NJBuilt 1977 · S/N 28-7790476 N4538TLarsen Jeffrey A · Spokane Valley, WABuilt 1972 · S/N 28-7205190 N4538XHicks Paul · Greenfield Center, NYBuilt 1975 · S/N 28-7625051 N4539X4539x LLC · Saint John, INBuilt 1975 · S/N 28-7615026 N453KCWindward Aviation Solutions LLC · Saint Marys, OHBuilt 1995 · S/N 3246015 N4540JDreyer Richard F · Springdale, ARBuilt 1968 · S/N 28R-30399 N4540RCase Herbert P · Wendell, NCS/N 28-21245 N4540TMurray Clifford K · Brunswick, GABuilt 1972 · S/N 28-7205181 N4541RBaker William D · Hyannis, NEBuilt 1965 · S/N 28-21246 N4541TUniversal Technical Institute Inc · Miramar, FLS/N 28R-7235083 N4541XPeachtree Air LLC · Wilmington, DEBuilt 1976 · S/N 28R-7635073 N4542JUht Christian M · Greenville, NYBuilt 1968 · S/N 28R-30402 N4542RBlue Skies Flying Club LLC · Painesville, OHBuilt 1965 · S/N 28-21247 N4543TNichols Curtis · Gloucester, VABuilt 1972 · S/N 28-7225183 N4544TJdc Aviation LLC · Upland, CABuilt 1972 · S/N 28R-7235085 N4544XHorsley D Jay · Fallon, NVBuilt 1975 · S/N 28-7615027 N4545XMeier Gordon T · San Diego, CABuilt 1975 · S/N 28-7690033 N4546RDr Se Flight Services LLC · Kansas City, MOBuilt 1965 · S/N 28-21252 N4547FSky Pilot Aviation Corp · Carlsbad, CABuilt 1976 · S/N 28-7790042 N4547RYeattes Michael K · Emporia, VABuilt 1965 · S/N 28-21253 N4547XBike Aviation LLC · Mason City, IABuilt 1975 · S/N 28-7610035 N4549RHamburg Airport 1 LLC · Williamsville, NYBuilt 1965 · S/N 28-21255 N4549TReinemer Rno Philip II · Carthage, TXBuilt 1972 · S/N 28R-7235086 N454CFlorida Coastal Flying Club LLC · Titusville, FLBuilt 1967 · S/N 28-23412 N454DLPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020273

Back to AD 87-08-08 R3