Registered aircraft · 22,411

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.

N1963JTeam Robinson Holdings LLC · Denver, NCS/N 328024038 N1963TCondor Aero Club Inc · Zelienople, PABuilt 1971 · S/N 28R-7135192 N1968TGilbert Zachary A · Jekyll Island, GABuilt 1968 · S/N 32-40376 N1969HTrn Aviation LLC · Mcallen, TXS/N 3257066 N1969TN1969 Tango LLC · Green Cove Springs, FLBuilt 1971 · S/N 28-7105199 N196HPSouthtrust Adventures LLC · Pensacola, FLBuilt 1996 · S/N 3246028 N196MTSheboygan Flying Club LLC · Sheboygan, WIBuilt 1964 · S/N 28-1880 N196SPParker Scott L · Galatia, ILBuilt 1974 · S/N 28-7415641 N196SQBay Land Aviation Inc · Salisbury, MDBuilt 1977 · S/N 32R-7780259 N1970HCape Fear Aviation Maintenance LLC · Fayetteville, NCBuilt 1977 · S/N 28-7716071 N1970PWootton Donald W · Houston, TXBuilt 1981 · S/N 32R-8129044 N1972KBachtac Aviation LLC · Clarksville, TXBuilt 1977 · S/N 32R-7780030 N1973GBarrette Michael Patrick · Saginaw, MIBuilt 1973 · S/N 28-7305358 N1973HAllen Quandt Inc · Grand Island, NES/N 28-7716073 N1978HHarow Peter M · Forked River, NJBuilt 1977 · S/N 28-7790364 N197DJN197dj LLC · Palm Harbor, FLBuilt 1997 · S/N 32-46074 N197SATalley Rentals LLC · Hobart, OKFirst renewal noticeBuilt 1963 · S/N 28-1087 N1980HEf Aviation LLC · Cape Coral, FLS/N 28R-7703044 N1980TSpiegel Kirk · San Luis Obispo, CABuilt 1971 · S/N 28-7105200 N1981HRegistration Pending · Saint Louis, MORegistration pendingBuilt 1977 · S/N 32-7700013 N1981TWatson Barrett Consulting LLC · Hermitage, TNS/N 28-7105201 N1982HWasley David L · Harwinton, CTBuilt 1977 · S/N 32R-7780212 N1983HGroeteke Robert W · Ravenna, NEBuilt 1977 · S/N 32R-7780213 N1984TGettelfinger Bart A · Indianapolis, INBuilt 1971 · S/N 28-7105202 N1986HTraining Planes LLC · Tampa, FLS/N 28R-7737022 N1987HFour C Sons Inc · Kersey, COBuilt 1977 · S/N 28R-7703046 N1988HKingdom Flying LLC · Inman, SCBuilt 1977 · S/N 32R-7780214 N1988TAtkins Robert M. · Hermosa Beach, CAFirst renewal noticeBuilt 1971 · S/N 28-7105203 N1989TJ3bar Pilot Services LLC · Garden City, KSBuilt 1971 · S/N 28R-7135203 N198FTOrtiz Santiago Gil · Miami, FLBuilt 1982 · S/N 28-8216198 N198GME B Marine LLC · Lantana, FLBuilt 1974 · S/N 32-7440126 N198JCLong Bayou LLC · Vero Beach, FLBuilt 1998 · S/N 3257028 N198SWFerguson Robert S · Riverview, FLBuilt 1977 · S/N 28-7890130 N198TLulfs Mark E · Mancelona, MIS/N 32-7200029 N198TCSky Ryder Aviation LLC · Lewisville, TXBuilt 1998 · S/N 3257047 N198WCy Properties Inc · Durango, COBuilt 1997 · S/N 3257012 N199Earth & Air LLC · Thompson Falls, MTBuilt 1964 · S/N 28-20568 N1990HTurner James Harvell · Montgomery, ALBuilt 1977 · S/N 28-7725175 N1992HBradley Aircraft Company LLC · Columbus, INBuilt 1977 · S/N 28-7716076 N1992TReel Aviation Inc · Delray Beach, FLBuilt 1971 · S/N 28-7105217 N1993HSmith Brian S · Spring, TXS/N 28-7790367 N1993TDenali Management Inc · Encino, CABuilt 1971 · S/N 28R-7135211 N1994THelisur USA LLC · Pembroke Pines, FLS/N 28R-7135187 N1995HFogarty Jayne I · Hartford, SDBuilt 1977 · S/N 28-7790369 N1995TMahmoud Khatib · Fayetteville, GABuilt 1971 · S/N 28-7105219 N1996HLord Alan T · Reynoldsburg, OHBuilt 1977 · S/N 28R-7737023 N1997HScarry Daniel · San Luis Obispo, CABuilt 1977 · S/N 28R-7703047 N1999SVernon Margo L · Friendship, TNBuilt 1969 · S/N 32-1162 N1999TFly Boys Ink LLC · Ellington, CTFirst renewal noticeBuilt 1971 · S/N 28-7110024 N199AVEcho Mike LLC · Baldwin, NYBuilt 1981 · S/N 28-8116283

Back to AD 87-08-08 R3