Registered aircraft · 6,238

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-18-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-18-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-18-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-18-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-18-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-18-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.

N702JKAlpha Whiskey Air Company LLC · Richardton, NDBuilt 1979 · S/N TH-1009 N703JMToller Kevin K · Broken Arrow, OKBuilt 1971 · S/N E-278 N703NCNunn Bryant · Canton, MIBuilt 1972 · S/N TH-224 N703THall Charles M · Lubbock, TXBuilt 1975 · S/N D-9816 N704BAiron2 LLC · Austin, TXBuilt 2001 · S/N E-3372 N705FSHvl Construction Inc · Fresno, CABuilt 1994 · S/N E-2836 N705GWFba Aviation LLC · Wildwood, FLBuilt 1991 · S/N TH-1631 N705NCEagle Leasing Inc · Gaylord, MIBuilt 1975 · S/N TH-595 N707AJRandy Goering Inc · Bend, ORBuilt 1979 · S/N E-1499 N707LAStowers Machinery Corp · Knoxville, TNBuilt 1993 · S/N TH-1685 N707LJFront Row LLC · Los Alamos, NMBuilt 1979 · S/N EA-4 N707MPEmmet Street Holdings LLC · Saint Petersburg, FLBuilt 1978 · S/N TJ-166 N707PWAtaraxia Aircraft Holdings LLC · Greenville, SCBuilt 1980 · S/N TH-1106 N707RDJones Alonzo · Los Angeles, CABuilt 1974 · S/N D-9708 N707TToth Michael · Wadsworth, OHBuilt 1976 · S/N E-861 N707WLFlight Solutions LLC · Chesterfield, MOBuilt 1983 · S/N TH-1377 N707ZHawley Elizabeth B · Wichita Falls, TXBuilt 1981 · S/N E-1978 N708MAFlying Machines LLC · Grand Ledge, MIBuilt 1981 · S/N TH-1304 N708WAltitude Aviation LLC · Missoula, MTBuilt 1985 · S/N E2269 N7092THidden Valley Aviation LLC · Denton, TXBuilt 1975 · S/N TH-664 N709JDBond John D · Prosper, TXBuilt 1979 · S/N E-1503 N709MAZephyrus Flyers LLC · Carson City, NVBuilt 1984 · S/N E-2117 N709TMitchell Marcinda Personal Representative · Sallisaw, OKBuilt 1978 · S/N E-1284 N70DRLanzillo Joseph H · Lancaster, PABuilt 1979 · S/N D-10224 N70DSArmstrong Harold E · Houston, TXBuilt 1976 · S/N CE-683 N70HCCamp John S · Los Gatos, CABuilt 1998 · S/N E-3172 N70MEAmsdell David A · Morgantown, WVBuilt 1978 · S/N D-10123 N70MVDawson Asset Management And Consulting LLC · Edgartown, MABuilt 1979 · S/N D-10222 N70PGAmerican Skyteam LLC · Floral Park, NYBuilt 1991 · S/N CE-1635 N70SLMcleod Sammy Dale Jr · Spring, TXBuilt 1986 · S/N EA-459 N70TBPauly Martin · Cedar Rapids, IABuilt 1978 · S/N E1289 N70TPBlack Eagle Aviation LLC · Livonia, MIBuilt 1987 · S/N CE-1153 N710ABAf-Aviation LLC · Miami, FLBuilt 1976 · S/N E-823 N710JBbs Aircraft Leasing LLC · Wellington, FLBuilt 1998 · S/N TH1850 N711AMNixon Bruce C · Portales, NMBuilt 1979 · S/N E-1487 N711ARFlying Burrito LLC · Placerville, CABuilt 1982 · S/N EA-284 N711GSSouth Delta Aviation Inc · West Helena, ARBuilt 1971 · S/N CE-333 N711HRMarshall Phillip W III · Enid, OKBuilt 1974 · S/N E-519 N711KMRegistration Pending · Cologne, MNRegistration pendingBuilt 1970 · S/N D-9106 N711NCHussey Aviation LLC · Clear Lake, IAS/N D-9776 N711PRDaniel Dewey · Okeechobee, FLBuilt 1974 · S/N E-608 N711SLAbc Leasing Inc · Oakdale, LABuilt 1978 · S/N CE-773 N711THTri-County Sprayers Inc · Hamlin, TXS/N E-246 N711VSMilne Jeff J · Lake Geneva, WIBuilt 1975 · S/N E-756 N712GDOsborne David · Texarkana, ARBuilt 1980 · S/N TH-1107 N712JZHeffley Brothers Flying Circus LLC · Benbrook, TXBuilt 1975 · S/N TH-671 N712LSDwyer Stephen C · The Woodlands, TXBuilt 1979 · S/N TJ-192 N7131Van Dyke Bryan C · Wichita, KSBuilt 1997 · S/N E-3093 N713MGMy Multifamily Investments LLC · Dallas, TXS/N D-10285 N713PVHodges Marion D · Princeton, KYBuilt 1990 · S/N CE-1515

Back to AD 87-18-06 R1