Registered aircraft · 54,017

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-20-03-R2') 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-20-03-R2') 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-20-03-R2')
    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-20-03-R2')
  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-20-03-R2')
  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-20-03-R2')
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.

N4708QCole Brent R · Anchorage, AKBuilt 1966 · S/N 185-1162 N4708VSpears Patricia C · Longmont, COBuilt 1953 · S/N 30165 N4709DMagalsky Jacob J · Wilsall, MTBuilt 1957 · S/N 34809 N4709KAlexander & Knizley Inc DBA · Mobile, ALBuilt 1975 · S/N 18263708 N4709RG & M Aircraft Inc · Wheat Ridge, COBuilt 1979 · S/N 172RG0013 N4709SMolinar Antonio L · El Paso, TXBuilt 1979 · S/N R18201395 N470EHKirkwood Aeronautics LLC · Bicknell, INBuilt 1976 · S/N 15077831 N470FSCustom Air International LLC · Homestead, FLBuilt 1973 · S/N 17262011 N470HDChandler Dennis · Castroville, TXBuilt 1958 · S/N 55288 N470JBLong James · Lyman, WYS/N 55041 N470JCCox Patrick A · Torrance, CABuilt 1972 · S/N 18052265 N470RVFlyguys Aviation LLC · Bay City, MIBuilt 1968 · S/N 18259314 N470XSale Reported · Priest River, IDSale reportedBuilt 1965 · S/N 18256370 N47108Ace Aircraft Leasing Inc · Nazareth, PABuilt 1979 · S/N 15283170 N4710QNeitz Frank A · Bethel, AKBuilt 1966 · S/N 185-1164 N4711BPinnacle Aviation Services Inc · Encinitas, CABuilt 1979 · S/N 15283591 N4711CN4711c Inc · Stillwater, MNBuilt 1958 · S/N 36623 N4711DTimmons Colton R · Parker, COBuilt 1957 · S/N 34811 N4711EOregon Seaplanes LLC · Canby, ORBuilt 1979 · S/N 18503845 N4711FCharter Equine Inc · Amarillo, TXBuilt 1966 · S/N P206-0311 N4711KFhk Inc · Verona, PABuilt 1975 · S/N 18263710 N4711LWings Over Texas Holdings LLC · Denton, TXBuilt 1980 · S/N 15284223 N4711VLiddy Alan A · Seabrook Island, SCS/N 172RG0368 N47120Shipe Jacqueline M · Louisville, TNBuilt 1979 · S/N 15283174 N4712DWerkema Thomas L · Caledonia, MIBuilt 1957 · S/N 34812 N4712KMclellan Bruce A Trustee · Bend, ORBuilt 1979 · S/N P21000262 N4712NTimberline Helicopters Inc · Sandpoint, IDBuilt 1979 · S/N 18267302 N4712XBludorn Matthew R · Bryan, TXBuilt 1966 · S/N 15064762 N47133Sunrise Aviation Inc · Ormond Beach, FLBuilt 1979 · S/N 15283178 N4713BSmith Peter J · Excelsior, MNBuilt 1979 · S/N 15283593 N4714BGeissler Charles H · Stanton, MNBuilt 1955 · S/N 31612 N4714CGorman Aviation LLC · Bartlesville, OKBuilt 1979 · S/N 21063596 N4714DWallace Brian T · Ogden, UTBuilt 1957 · S/N 34814 N4714FHastings Stephen J · Palmer, AKS/N 17273075 N4714KJld Air LLC · North Hampton, NHBuilt 1976 · S/N R1722016 N4714NOwen John E · Aiken, SCBuilt 1979 · S/N 18267303 N4714RAlford William J · Erie, MIBuilt 1979 · S/N 172RG0014 N4714XHoffman Zachariah M T · Glendale, AZBuilt 1966 · S/N 15064764 N4715DPetracca Carmine J · Lewiston, IDBuilt 1957 · S/N 34815 N4715FRegistration Pending · Ukiah, CARegistration pendingBuilt 1966 · S/N P206-0315 N4715JClarke Brent H · Neversink, NYS/N 17273666 N4715KSki Town Aviation Management LLC · Steamboat Springs, COBuilt 1975 · S/N 18263714 N4715WKelley Christopher L · La Quinta, CABuilt 1980 · S/N P21000624 N4715XBlair Ross Iain · Milford, NJBuilt 1966 · S/N 15064765 N4716BClose Keith · Anchorage, AKBuilt 1955 · S/N 31614 N4716DDavenport Reginald · Evans, WABuilt 1957 · S/N 34816 N4716KGlobal Acquisition Ltd · Davenport, IABuilt 1975 · S/N 18263715 N4716NHolcombe Aaron L · Jay, OKBuilt 1979 · S/N 18267305 N4716XJessup Sheila · Dublin, CABuilt 1980 · S/N U20605527 N4717BCoastal Flight Inc · Tierra Verde, FLBuilt 1979 · S/N 15283595

Back to AD 87-20-03 R2