Registered aircraft · 72,007

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-10-06-R1') 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-10-06-R1') 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-10-06-R1')
    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-10-06-R1')
  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-10-06-R1')
  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-10-06-R1')
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.

N30CEWren Aircraft LLC · Menlo Park, CABuilt 2003 · S/N 0001 N30CPSkyveris LLC · Simi Valley, CABuilt 1973 · S/N 27-7305022 N30CSAdams Brad A · Soldotna, AKBuilt 1957 · S/N 18-5409 N30DDRegenstein Jacob · San Francisco, CABuilt 1992 · S/N 20349 N30DFDae Aviation Enterprises Corp · Gilford, NHBuilt 1974 · S/N 31-7401263 N30DRRuble Force One LLC · Wilkinson, INBuilt 1978 · S/N 31-7912006 N30DSSaver Matthew S · Lebanon, TNBuilt 2003 · S/N 81482 N30DWHeffernan Michael James · Wellesley, MABuilt 1971 · S/N 28R-7135229 N30ECVogt Timothy J · Houston, TXBuilt 1997 · S/N 1284 N30ERRance Cory · Moody, TXBuilt 2020 · S/N T-169 N30FATerra Ferma Inc · Wilmington, DENon-citizen corporation, flight hours not reportedBuilt 1963 · S/N 30-59 N30FCState Alabama Forestry Commission · Florence, ALFirst renewal noticeBuilt 1982 · S/N R18201913 N30FHBaldwin Jonathan B · East Boothbay, MEBuilt 1973 · S/N 34-7350203 N30FMM20j LLC · Niceville, FLBuilt 1997 · S/N 24-3410 N30GSClausen Robert G · Argyle, MNBuilt 1973 · S/N 17261470 N30HUDukes William R · Tallulah, LABuilt 1998 · S/N 1406 N30JAJahawk Leasing LLC · Sugar Grove, ILBuilt 1976 · S/N 17268043 N30JBBalbierer John M · Columbus, MSBuilt 1998 · S/N 23892 N30JGAdamson Don · Lonoke, ARBuilt 1976 · S/N 1369 N30JKThompson Troy L · Amarillo, TXS/N 732 N30JPPhilpott Connor J Ryan · Newbury Park, CABuilt 1977 · S/N 1-0052 N30JSFixed Wing Holding Co Inc · Pembroke Pines, FLBuilt 1977 · S/N 28R-7837100 N30JTMatthews William P · Blacksburg, VAS/N 80903 N30JVJasper Aviation Inc · Jasper, ALBuilt 1964 · S/N TD-597 N30JXOptimal Aviation Services LLC · Visalia, CABuilt 1964 · S/N 30-539 N30KWWeeks Kermit A · Polk City, FLBuilt 1974 · S/N 003 N30LERollins Robert · Gadsden, ALBuilt 1971 · S/N 28R-7235018 N30LVNorth Arkansas Aviation LLC · Paragould, ARS/N 28-7916098 N30MEKustudich Tim · Holland, MIBuilt 1985 · S/N MICKELSON-0001 N30NKOlah Michael J · Mazomanie, WIBuilt 1984 · S/N 162 N30NWCenterline Aerospace Inc · Clermont, FLFirst renewal noticeBuilt 1964 · S/N 30-312 N30PMReimer Lynn C · Sioux Falls, SDS/N 2 N30PSRosendahl Greg C · Boulder, COS/N K081 N30RHHalye Roger J · Port Orange, FLBuilt 1977 · S/N 17269998 N30RVHarris John W · Lewisville, TXBuilt 1999 · S/N 2025 N30SAMsm30sa LLC · Jericho, NYS/N 31-7952142 N30SBFlare LLC · Chattanooga, TNBuilt 2004 · S/N 955-2004 N30SCRegistration Pending · Wauchula, FLRegistration pendingBuilt 1981 · S/N 31-8152098 N30SHMedic Choppers LLC · Springdale, ARBuilt 1966 · S/N 30-1262 N30SXRegistration Pending · Painesville, OHRegistration pendingBuilt 1992 · S/N 3025 N30TJFiskars Equipment Co · Saint Joseph, MIBuilt 1965 · S/N 30-762 N30TPLe Ciel Bleu LLC · Hudson, WIBuilt 1981 · S/N 31-8152062 N30TSAv8rs LLC · Gig Harbor, WABuilt 1994 · S/N 156 N30VBGroundrush Entertainment · Beaverton, ORBuilt 2004 · S/N 10425 N30WHAcme Aerosports Inc · Huntsville, ALBuilt 1977 · S/N 997-77 N30WWHr Air LLC · Lakeland, FLBuilt 1994 · S/N 1 N30XTBurnette Ric A · Sebastian, FLBuilt 1967 · S/N 30-1644 N30YDAndre John D · Chesapeake, VABuilt 1998 · S/N 23555 N3100Meyer Matthew D · Redding, CABuilt 1967 · S/N 491421 N31006Tanner Paul L · Savoy, TXBuilt 1978 · S/N 489-H

Back to AD 87-10-06 R1