Skip to content

Registered aircraft · 54,015

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.

N8134FHammond Steven R · Trenton, MOBuilt 1966 · S/N 15064234 N8134UColey Lee · Fayetteville, GABuilt 1964 · S/N 17252034 N8134XLugas Grant A · Elyria, OHBuilt 1961 · S/N 17248634 N8135SMcjunkin John Michael · Portland, ORRegistration revokedBuilt 1965 · S/N 15061735 N8135XMatarelli Robert E Jr · Carlton, MNBuilt 1961 · S/N 17248635 N8136ARedman Thomas F · Talkeetna, AKBuilt 1952 · S/N 20988 N8136BStanley Mark E · Paso Robles, CABuilt 1957 · S/N 29936 N8136FRawson Aviation LLC · Ardmore, OKBuilt 1966 · S/N 15064236 N8136MTakeair LLC · Incline Village, NVBuilt 1976 · S/N 18264546 N8136SPockrus Pat B · Mineral Wells, TXS/N 15061736 N8136UMoors Thomas G · Wentzville, MOBuilt 1964 · S/N 17252036 N8136XStevenson George Otis · Wheatland, WYBuilt 1961 · S/N 17248636 N8137BKelly James E · Accord, NYBuilt 1957 · S/N 29937 N8137GTwo Ten K LLC · Upper Sandusky, OHBuilt 1971 · S/N 21059437 N8137LShreve Jerry · Warrensburg, MOBuilt 1974 · S/N 21060624 N8137XHarritt Roger · Anchorage, AKBuilt 1961 · S/N 17248637 N8137ZSullivan Harry Stuard Trustee · Banning, CABuilt 1962 · S/N 205-0137 N8138ANelson Richard W · Edna, TXBuilt 1952 · S/N 20990 N8138GRab Com Limited · Hayward, CABuilt 1971 · S/N 21059438 N8138LN8138l LLC · Metairie, LABuilt 1978 · S/N A1520828 N8138QAnderson Marshall H · Anchorage, AKBuilt 1978 · S/N 18503633 N8138TSvoboda Patrick J · Bucyrus, KSBuilt 1960 · S/N 17556838 N8138UBurner Dwight L · Mc Gaheysville, VABuilt 1976 · S/N 15077899 N8138XHarris David L · Wichita, KSFirst renewal noticeBuilt 1961 · S/N 17248638 N8139BDavies Lincoln J · Oostburg, WIBuilt 1957 · S/N 29939 N8139LWashburn Kyle A · Yukon, OKBuilt 1974 · S/N 21060626 N8139USemanskee Grant W · Snohomish, WABuilt 1976 · S/N 15077900 N8139XMerkle Patrick G · Washington, DCBuilt 1961 · S/N 17248639 N813DMAp-1 LLC · Newman Lake, WABuilt 1975 · S/N 21060946 N813HYOcala Aviation Services Inc · Ocala, FLBuilt 1964 · S/N 17252033 N813JWComanche Air Inc · Tacoma, WAFirst renewal noticeBuilt 1972 · S/N 177RG0294 N813MDHanks Thomas M · Carlsbad, CABuilt 1953 · S/N 25957 N813SWWolff Scott · Missoula, MTBuilt 1979 · S/N U20605296 N8140BOlson Larry G · Walnut Creek, CABuilt 1957 · S/N 29940 N8140UAnderson Milton M · Twin Bridges, MTS/N 17252040 N8140XHubbell Carl · Crowley, TXBuilt 1961 · S/N 17248640 N8141GBitter Creek Investments LLC · Cascade, IDS/N 21059441 N8141SRegistration Pending · La Porte, TXRegistration pendingBuilt 1965 · S/N 15061741 N81424Wbair LLC · Wills Point, TXS/N 17256218 N8142AKiel Donald G · Whitelaw, WIBuilt 1952 · S/N 20994 N8142BJones Ronald E · Cromwell, CTBuilt 1957 · S/N 29942 N8142SRebich Jason F · Overton, NVBuilt 1965 · S/N 15061742 N8142TRodriguez Pablo · Toa Baja, PRBuilt 1960 · S/N 17556842 N8142UMartin Ralph Edward · Jonesboro, ARBuilt 1964 · S/N 17252042 N8142VKing Kevin J · Angle Inlet, MNBuilt 1974 · S/N A1500538 N8142XWhitehead Daniel · New Providence, IABuilt 1961 · S/N 17248642 N8142ZHayes Allen D · La Grange, KYBuilt 1962 · S/N 2050142 N8143ALiimatainen William J · Monroe, WIBuilt 1952 · S/N 20995 N8143GRegistration Pending · Sparks, NVRegistration pendingBuilt 1971 · S/N 21059443 N8143SElite Aeronautics LLC · Carolina, PRBuilt 1965 · S/N 15061743

Back to AD 87-20-03 R2