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.

N4165LValiair Limited Co Trustee · Tucson, AZS/N 3257129 N4165UInter American University Of Puerto Rico · Bayamon, PRBuilt 1998 · S/N 2843200 N41667Lewis Clifton Jack · North Branch, MIBuilt 1974 · S/N 28-7415116 N41669Hogan Daniel L · Chapel Hill, NCBuilt 1974 · S/N 28-7415312 N4166FStalworth Leasing Inc · Burr Ridge, ILBuilt 1999 · S/N 2843263 N4166HBird Acquisition LLC · Phoenix, AZBuilt 1998 · S/N 2843119 N4167DCraft Air Ventures LLC · Lake Jackson, TXBuilt 2000 · S/N 3257138 N4167KSkywest Leasing Inc · St George, UTBuilt 2000 · S/N 2843342 N4167LPlane Nonsense Inc · Middletown, DEBuilt 2000 · S/N 2843318 N4167NS&T Aviation LLC · Missoula, MTS/N 3257170 N4167RZorychta Mary Ann · Clinton, ARBuilt 1968 · S/N 32-40483 N4167SSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2000 · S/N 3257153 N4168JTwigg Donald A · Cumberland, MDBuilt 1966 · S/N 28-22503 N4168RJones Donald T Jr · Barrigada, GUBuilt 1968 · S/N 32-40484 N4168SDrew Dennis M · Danville, CABuilt 2000 · S/N 3257159 N4168ZRc Aviation LLC · Grimes, IABuilt 2000 · S/N 3246169 N4169FRoelker Randall S · San Antonio, TXBuilt 1976 · S/N 28-7715007 N4169RWollen Mark A · Poway, CABuilt 1968 · S/N 32-40566 N4169TMiller Kenneth · Henderson, NVBuilt 2003 · S/N 3257313 N416CACoast Flight Training And Management Inc · Dallas, TXBuilt 2019 · S/N 2881121 N416HPKt7 Aviation LLC · Katy, TXBuilt 1963 · S/N 28-1437 N416JLCondren Ryan · Sunnyvale, TXBuilt 1967 · S/N 28-23944 N416MPKma Aviation LLC · Maitland, FLBuilt 1977 · S/N 32R-7780526 N416PASkywest Leasing Inc · St George, UTBuilt 2001 · S/N 2843438 N416RPMiller Aircraft Services Inc · Crookston, MNBuilt 1974 · S/N 28-7415310 N416TSSutton Nathan M · Houma, LABuilt 1998 · S/N 3246100 N41703Sweeny Daniel L · Parrish, FLBuilt 1974 · S/N 28-7405134 N4170JMoscrip Mark D · La Vernia, TXS/N 28-22505 N4170LOsborn Allan R Trustee · Springfield, VABuilt 2000 · S/N 28-43387 N4170TVwfusco Aircraft Management LLC · Stratford, CTBuilt 2000 · S/N 2843390 N4170VPi High Flight LLC · Lancaster, PABuilt 2000 · S/N 3257141 N4170WWilson Troy L · Raton, NMBuilt 1967 · S/N 32-40249 N41714Nunn Ethan Edwin · Melba, IDS/N 28-7415316 N41718Baker Thomas David · Noble, ILBuilt 1974 · S/N 28-7415318 N4171XGailing Jessica L · Costa Mesa, CABuilt 2000 · S/N 2843349 N41723Sale Reported · Greensboro, NCSale reportedBuilt 1974 · S/N 28-7415320 N4172DChristiansen Aviation LLC · Wilmington, DEBuilt 2000 · S/N 2843400 N4172JAscension Enterprises Inc · Saint Augustine, FLBuilt 1966 · S/N 28-22508 N4172RRedemption Inc · Kodiak, AKBuilt 1968 · S/N 32-40505 N4172TMajor Michael S · Ogden, UTBuilt 2000 · S/N 3257158 N4172ZMathew Priya Trustee · Utica, NYS/N 2843384 N41731Novak Michael · Chicago, ILBuilt 1974 · S/N 28R-7435213 N41738Dadson Aviation LLC · Lowell, INBuilt 1974 · S/N 28-7415321 N41739Triple Nickel Inc · Muleshoe, TXS/N 28-7415322 N4173AE Hospital Services Inc · Houston, TXFirst renewal noticeBuilt 2000 · S/N 3257146 N4173DCw Flyers Ltd · Wilmington, DEBuilt 2000 · S/N 2843334 N4173RWilliams Paul D · Gunnison, COBuilt 1968 · S/N 32-40507 N4173WGordon Jacques L Dmd · Atlanta, GABuilt 1967 · S/N 32-40252 N4174AGutwein Harvey R · Francesville, INBuilt 2000 · S/N 3246174 N4174CZierhut Kurt P · Camarillo, CABuilt 2000 · S/N 3246167

Back to AD 87-08-08 R3