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.

N1889JBrain James E Jr · Rogers, ARBuilt 1968 · S/N 28-24334 N188ABSafford Aviation Service Inc · Coolidge, AZBuilt 1969 · S/N 32-40884 N188DXPiper Aircraft Inc · Vero Beach, FLS/N 28010104 N188SEChernov Boris · Lima, OHBuilt 1978 · S/N 32R-7885255 N188SPThornado Aviation LLC · Indialantic, FLBuilt 1977 · S/N 32R-7780309 N1892TB&R Aircraft LLC · Wadsworth, OHBuilt 1971 · S/N 28-7225042 N1894TIrish Dennis W · Erie, PABuilt 1971 · S/N 28-7225023 N1895JMellowship Stuart R · Zionsville, PABuilt 1968 · S/N 28-24340 N1896JWestern Edge Aviation LLC · Dickinson, NDBuilt 1968 · S/N 28-24342 N1897JGrimes Joseph Daniel · Kennewick, WABuilt 1968 · S/N 28-24343 N1897TMortgage Experts LLC · Homestead, FLBuilt 1971 · S/N 28-7225046 N1898JNorris Joseph M · Palatka, FLBuilt 1968 · S/N 28-24344 N189CSHelo-Max LLC · Dublin, GABuilt 2021 · S/N 28020039 N189ECCollins Richard · Oceanside, NYS/N 28-8290061 N189JBSpin Off Aircraft LLC · West Palm Beach, FLBuilt 1979 · S/N 28-7990190 N189MJBarnes Aviation LLC · Flowood, MSBuilt 2004 · S/N 3257340 N189RPElferdink Steven · Naples, FLBuilt 2006 · S/N 3257410 N189SPKilpatrick Blake E · Canyon Lake, TXS/N 28-8016137 N18BRFly Ohio Inc · Columbus, OHBuilt 1966 · S/N 32-371 N18FTSk Ventures LLC · Hamilton, MTBuilt 1976 · S/N 32-R-7780126 N18KNAeroventures Flying Club Inc · Lilburn, GABuilt 1979 · S/N 28-7911297 N18LHKrystal Sky Aviation LLC · Melbourne, FLBuilt 1998 · S/N 32-57058 N18MUHobgood Mitchell D · Tylertown, MSS/N 28-3561 N18SWShannon Kenneth J · Cleveland, TXBuilt 1973 · S/N 28-7425049 N18WMIsland Cay Express Inc · Wilmington, DEBuilt 1980 · S/N 32-8006047 N18WRN18wr LLC · Mesa, AZS/N 28-8190185 N1901HLuing Daniel M · Chippewa Falls, WIBuilt 1977 · S/N 28-7716059 N1902HAbraxis Air LLC · Casa Grande, AZBuilt 1977 · S/N 28-7716060 N1903HEsp Aviation LLC · Mason City, IABuilt 1977 · S/N 28-7790351 N1904HSpyropoulos Basil P · Lake Geneva, WIBuilt 1977 · S/N 28-7790352 N1906HTriplett Gregory L · Holden, MOBuilt 1977 · S/N 32R-7780199 N1908HSandlin James B · Surgoinsville, TNBuilt 1977 · S/N 32R-7780201 N1909UBranch Stephanie B · Papillion, NEBuilt 1974 · S/N 28-7425215 N190FTWestchester Flying Club Inc · Purchase, NYBuilt 1978 · S/N 28R-7837245 N190PHJohnson Cameron M · Worthington, MNBuilt 1977 · S/N 32-7740064 N1910TBrown James E · Wind Lake, WIBuilt 1971 · S/N 28-7125464 N1911TSnp Aviation LLC · Avoca, IABuilt 1971 · S/N 28-7125412 N1911VLefort Charles J · Redding, CABuilt 1974 · S/N 28-7405103 N1912THillman Motors Inc · Winter Haven, FLBuilt 1971 · S/N 28R-7135130 N1913HOllie And Wally Airlines LLC · Auburn, WABuilt 1977 · S/N 28-7716061 N1913TWilliams Ronald P · Woodway, TXBuilt 1971 · S/N 28-7125474 N1914HMiloud Chadd K · Fort Worth, TXBuilt 1977 · S/N 28-7716062 N1915TAeromx LLC · West Jefferson, OHBuilt 1971 · S/N 28R-7135132 N1918TThompson Todd · Elmore, MNBuilt 1971 · S/N 32-7140060 N191BCZabrosky Air LLC · Cedar Hills, UTBuilt 1973 · S/N 28R-7435088 N191RVSpurgeon Michael · Nashville, TNBuilt 1978 · S/N 32R-7887051 N1923HGardner Christopher M · Mankato, MNBuilt 1977 · S/N 28-7725168 N1924HSkyjiro Forge Corp · Arcadia, CABuilt 1977 · S/N 28-7725169 N1927HAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1977 · S/N 28R-7737017 N192AMN34cc LLC · Liberty, NCBuilt 2021 · S/N 2881507

Back to AD 87-08-08 R3