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.

N4932NSan Juan Flyers Inc · Pagosa Springs, COBuilt 1979 · S/N 18267460 N4932SThunder Aviation LLC · Oro Valley, AZBuilt 1980 · S/N R18201471 N4933QDarter Lloyd R · Mountain Grove, MOBuilt 1976 · S/N 18802668T N4933SHedden Larry H · Huntsville, ALBuilt 1980 · S/N R18201334 N49341Dale Michael E · Murrieta, CABuilt 1979 · S/N 15283449 N4934AYellowstone Overflight Inc · Belgrade, MTBuilt 1956 · S/N 32331 N4934EHeineman Steven · Chicago, ILBuilt 1979 · S/N 18503912 N4934SFerrell Charles A · Stockton, CABuilt 1980 · S/N R18201473 N4934USatriana Robert L · Belen, NMBuilt 1965 · S/N 21058634 N4935AVucetic Miroslav · Coral Springs, FLBuilt 1956 · S/N 32332 N4935GKip'S Flying Service LLC · Bankston, ALBuilt 1979 · S/N 17273482 N4935QHaygar Berlin Inc · Shorewood, MNBuilt 1978 · S/N 18503578 N4936AAnderson Dennis G · Eagle River, AKBuilt 1956 · S/N 32333 N4936NSwett Alan · Panora, IABuilt 1979 · S/N 18267463 N4936TDakma LLC · Parma, OHBuilt 1981 · S/N R18201794 N4937GInternational Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N 17273484 N4937PMorcom Aviation Services Inc · Everett, WABuilt 1981 · S/N 15284849 N4937RAllred Bobby A · Centre, ALBuilt 1975 · S/N 18802454T N4937SRauch James A III · Cayce, SCBuilt 1980 · S/N R18201476 N4937TSalsbery Enterprises Inc · Sharpsville, INBuilt 1981 · S/N R18201795 N4938HAir Poueir LLC · Amarillo, TXBuilt 1979 · S/N 15284033 N4938TTilney Five LLC · Belleair, FLBuilt 1981 · S/N R18201796 N4939CBard Ralph M · Tullahoma, TNBuilt 1979 · S/N 21063680 N4939RMiller Farms Jv · Opheim, MTBuilt 1975 · S/N 18802456T N4939SLeriche Daniel R · Wolcott, VTBuilt 1980 · S/N R18201478 N4939VFlorida Keys Flight Academy LLC · Marathon, FLBuilt 1980 · S/N 172RG0420 N4939YDavidson Dan F · Ozona, TXBuilt 1980 · S/N 21064050 N4939ZStaheli Lee E · Kiana, AKS/N U20606053 N493BTRegistration Pending · Deltona, FLRegistration pendingBuilt 1975 · S/N 17702318 N493SHForsman David G Co-Trustee · South Haven, MNBuilt 1968 · S/N 17256881 N493WCOsness Rhonda R · Bisbee, NDBuilt 1973 · S/N P3370090 N49404Central Virginia Aviation Inc · North Dinwiddie, VABuilt 1977 · S/N 15281240 N4940ASims Charles A · Chugiak, AKBuilt 1956 · S/N 32337 N4940DAirborne One LLC · Kalispell, MTS/N 51040 N4940EFlyright Aviation Inc · North Las Vegas, NVBuilt 1978 · S/N 17271681 N4940GN4940g LLC · Portsmouth, NHS/N 17273487 N4940KGoves Abram M · Parker, COBuilt 1979 · S/N P21000376 N4940NWray James R Jr · Brighton, COBuilt 1979 · S/N 18267465 N4940SO'Gorman Robert W Jr · Wake Forest, NCBuilt 1980 · S/N R18201479 N49417Rich John E · Dunnellon, FLS/N 15281248 N49419Ds Flight Services LLC · Battle Ground, WAS/N 15281250 N4941FPaddock Levi · Springfield, ORS/N U206-0641 N49423Johnson Shem E · Bonners Ferry, IDBuilt 1978 · S/N 15281254 N49424Xin Han Aviation LLC · Atwater, CABuilt 1978 · S/N 15281255 N4942AChapman Peter E · Placerville, CABuilt 1956 · S/N 32339 N4942DN4942d LLC · Greenfield, NHBuilt 1958 · S/N 51042 N4942HFlorida Flyers Flight Academy Inc · Saint Augustine, FLBuilt 1979 · S/N 15284036 N4942UCenturion LLC · Bonney Lake, WABuilt 1965 · S/N 21058642 N49432Northshore Group LLC · Wilmington, DEBuilt 1978 · S/N 15281262 N49434California In Nice Inc · San Jose, CABuilt 1979 · S/N 15283458

Back to AD 87-20-03 R2