Registered aircraft · 72,010

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.

N425BZMcgrath Robert J · Simpsonville, SCBuilt 2007 · S/N 40234 N425CAHowell Norman · Port Orange, FLBuilt 1977 · S/N 61P-0425-156 N425CBSummit Flight Academy LLC · Peculiar, MOBuilt 1974 · S/N 28-7415210 N425CHKeeton Farms LLC · Monticello, KYBuilt 1966 · S/N 32-770 N425CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 2001 · S/N 172S8687 N425DBWings Over Texas Holdings LLC · Denton, TXBuilt 1975 · S/N 17266404 N425DLTotal Flight Aircraft Leasing LLC · Apex, NCBuilt 1979 · S/N 172RG0143 N425DPKuhn Alexander G · Fairfield, CTBuilt 1978 · S/N 28R-7837174 N425FLFrogtown Investments LLC · Owensboro, KYBuilt 1971 · S/N 28-7125208 N425FPUtah State University · Logan, UTBuilt 2006 · S/N 40.FC025 N425HACci Air LLC · Albion, MIBuilt 2004 · S/N 3246219 N425JMccracken Lester G · Edinboro, PABuilt 1958 · S/N TD-57 N425JVBarnes Timothy K · Chapel Hill, NCBuilt 2004 · S/N 2844112 N425KTBartley Terrence E · Port Orange, FLBuilt 2002 · S/N 425 N425KWWooten Kurt R · Wichita, KSBuilt 2014 · S/N 14001 N425NM425nm Inc · Denver, COBuilt 2000 · S/N 0011 N425PABas Part Sales LLC · Greeley, COBuilt 2001 · S/N 2843474 N425PKGood Flight LLC · San Luis Obispo, CABuilt 2004 · S/N 18281449 N425RHelmkamp Janet K · Bethalto, ILBuilt 1995 · S/N 124 N425RTN425rt LLC · Kalispell, MTS/N 1004 N425RVRegistered aircraftBuilt 2007 · S/N 72117 N425SQSpinola Hernandes M · Homestead, FLS/N 23-1376 N426Jarrett Franklin · Ivyland, PABuilt 1996 · S/N 1339 N4260JSchroeder Gregory M · Saline, MIBuilt 1967 · S/N 28-22658 N4260QLevin Robert G · Roseburg, ORBuilt 1971 · S/N 17260160 N4260RColin Irons Diving And Pool Service · Crawfordville, FLBuilt 1969 · S/N 32-40634 N4261CGidzinski David A · Weirsdale, FLBuilt 1954 · S/N E3B-329 N4261EConger Jon W · Cottonwood Heights, UTBuilt 2000 · S/N 33001C N4261JMathison John M · Vancouver, WABuilt 1967 · S/N 28-22618 N4262Regal Dent Inc · Goshen, NYFirst renewal noticeBuilt 2006 · S/N 2843647 N4262ARamaswamy Ashok · Clearwater Beach, FLS/N 27105 N4262HNorthern Iowa Anesthesia Services P L C · Ames, IAS/N 24-0688 N4262JBeaverdam Aeronautics LLC · Chatom, ALS/N 28-22619 N4262PPower Willis H · Weatherford, TXS/N 23-1761 N4262RKirkpatrick Alan E · Oklahoma City, OKS/N 32-40636 N4263HSchneider Michael J · Anchorage, AKBuilt 1948 · S/N 14-67 N4263JBmf Wings LLC · Corinth, MSBuilt 1967 · S/N 28-22620 N4263ZPlane Fun Inc Tr Trustee · Snellville, GABuilt 1966 · S/N 18-8493 N4264AReed William B · Cortlandt Manor, NYBuilt 1947 · S/N NAV-4-606 N4264DKnisely Kevin R · Lapeer, MIBuilt 2000 · S/N 27002C N4264FNack Kim R · Wentzville, MOBuilt 1994 · S/N 1030 N4264PFergason John S · Louisville, OHBuilt 1961 · S/N 23-1763 N4264QAlbrecht Paul J · Mine Hill, NJBuilt 1971 · S/N 17260164 N4264TSmith John W · Cold Spring, NJBuilt 1972 · S/N 28-7205124 N4264ZAllen Steven L · Thatcher, AZBuilt 1967 · S/N 18-8507 N4265HAngel Aviation Inc · Peoria, AZBuilt 1948 · S/N 14-69 N4265QParrish Aviation Flight Academy LLC · Southlake, TXS/N 17260165 N4265ZBaklarz Ralph B · Eagle River, AKBuilt 1967 · S/N 18-8508 N4266BCarpenter Steven Warren · Inver Grove, MNBuilt 2000 · S/N 26009C N4266JMarvin Carlton R · Tomahawk, WIBuilt 1967 · S/N 28-22623

Back to AD 87-10-06 R1