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.

N4VTUp And Up Aviation LLC · Magnolia, TXBuilt 1985 · S/N 28-8616015 N4WBBe Positive Holdings LLC · Bloomsburg, PABuilt 1977 · S/N 32R-7880018 N4YPBobs Biz Ltd · Minster, OHBuilt 1999 · S/N 2843284 N5001WHayes Gregory S · Erie, PABuilt 1962 · S/N 28-2 N5002SAsasnoceu LLC · Fort Myers, FLBuilt 1970 · S/N 28R-35726 N5002TPenn Yan Flying Club Inc · Penn Yan, NYBuilt 1972 · S/N 28-7205237 N5004WN5004w LLC · Kansas City, MOBuilt 1961 · S/N 28-5 N5005TWeekend Air LLC · Incline Village, NVBuilt 1972 · S/N 28-7225308 N5005WManxhuka Dukagjin · Ridgefield Park, NJBuilt 1961 · S/N 28-6 N5006SOracle Aviation LLC · Omaha, NEBuilt 1971 · S/N 28-7110011 N5007SSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1970 · S/N 28R-35731 N5007TLara Jess D · Albuquerque, NMBuilt 1972 · S/N 28-7225310 N5008TS E D Air LLC · Kimball, SDBuilt 1972 · S/N 28-7225311 N5008WZanier Aldo M · Long Beach, CABuilt 1961 · S/N 28-9 N5009WRegistration Pending · Americus, GARegistration pendingBuilt 1961 · S/N 28-10 N500AFAmerican Air Academy Inc · Merritt Island, FLBuilt 2020 · S/N 28020001 N500DPO'Rourke Lawrence · Montgomery, PAS/N 28R-30391 N500FWWohltman Valerie A Trustee · Effingham, ILBuilt 1979 · S/N 28-7990431 N500GLEumundi Trading Company · Wilmington, DEBuilt 1978 · S/N 28R7803284 N500GSCloud Chaser Aviation LLC · Chesnee, SCBuilt 2005 · S/N 2843611 N500KCRuiz Edinson · Bakersfield, CAS/N 28-7325667 N500LHParis Air Inc · Vero Beach, FLBuilt 1978 · S/N 28-7916240 N500NPVolare Air LLC · Palm Harbor, FLBuilt 1974 · S/N 28R-7435168 N500SGSimplicity Inc · Redmond, ORBuilt 2004 · S/N 3232020 N500VBParagon Airplane Leasing Co · Fort Myers, FLBuilt 2022 · S/N 28020101 N500WCRickey Donald N · Murfreesboro, TNBuilt 2004 · S/N 3232019 N5010SAeroflyte LLC · Glastonbury, CTBuilt 1970 · S/N 28R-35735 N5010TN5010t LLC · Arcadia, OKS/N 28R-7235171 N5013SFlightworks LLC · North Myrtle Beach, SCBuilt 1970 · S/N 28R-35740 N5013TDasilvafontoura Peterson · Santa Clarita, CABuilt 1972 · S/N 28R-7235173 N5014SGandy Austin T · Channelview, TXS/N 32-7100018 N5014TGalati David R · Sebring, FLBuilt 1972 · S/N 32-7240098 N50169Goddard Jake W Jr · Perry, GAS/N 32R-7680110 N5019SGordon Patricia I · Desoto, TXS/N 28R-35751 N5019WShipley Kelly R · Astoria, ORBuilt 1961 · S/N 28-20 N501BTCloud Chasers LLC · Columbus, MSBuilt 1976 · S/N 32R-7780039 N501MAContinental Aerospace Technologies Inc · Mobile, ALBuilt 2021 · S/N 2881479 N501SGMccair LLC · Mineral Wells, TXBuilt 1983 · S/N 32-8306003 N501WPTrue Course Aviation LLC · Ashville, NYBuilt 1977 · S/N 32R-7780476 N5020SSchneider Robert R · Fort Benton, MTS/N 28R-35753 N5020TBetlach Christopher Thomas · Kenmore, WABuilt 1972 · S/N 28R-7235175 N5020YStandridge Robert M · Norman, OKS/N 3246187 N5023SSummit Arrow Adventures LLC · Peyton, COBuilt 1970 · S/N 28R-35759 N5024SGuy Timothy S · Henderson, NVBuilt 1970 · S/N 28R-35760 N5024TMoore Jason J · Spanish Fort, ALBuilt 1972 · S/N 28-7225320 N5025SAir Cover Academy LLC · Frankford, MOBuilt 1970 · S/N 28R-35761 N5025TRoney William A · Santa Fe, NMBuilt 1972 · S/N 28-7225321 N5026WSpencer Don W · The Dalles, ORBuilt 1961 · S/N 28-27 N5027SRatliff Thomas E · Tomball, TXS/N 28R-35771 N5027TMohre Steve G · Blakeslee, OHBuilt 1972 · S/N 28R-7235177

Back to AD 87-08-08 R3