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.

N761XZKrabill Enterprises LLC · Christmas Valley, ORBuilt 1978 · S/N 21062613 N761YDAero Clean Technologies LLC · Lynchburg, VABuilt 1978 · S/N 21062617 N761YEUnique Educational Experiences Inc · Signal Hill, CABuilt 1981 · S/N A1520997 N761YGGoody Birds LLC · Prattville, ALBuilt 1978 · S/N 21062620 N761YHArnett Family Inc · Mesa, AZS/N 21062621 N761YKFanning Fred W · Fairlawn, OHBuilt 1978 · S/N 21062623 N761YMSkyberry Jam Aviation LLC · Coppell, TXS/N 21062625 N761YSThompson Gary P · Mammoth Lakes, CABuilt 1978 · S/N 21062630 N761YWWalker Gilbert C · Camerillo, CABuilt 1978 · S/N 21062634 N761ZBIts Academic Inc · Elyria, OHBuilt 1978 · S/N 21062639 N761ZEBrandvik Pipe & Equipment Inc · Borger, TXS/N 21062642 N7620GDc Aero LLC · Ramona, CABuilt 1970 · S/N 17259320 N7620XRegistered aircraftBuilt 1960 · S/N 17248120 N7621GCrewdawg Aviation LLC · Concord, NCBuilt 1970 · S/N 17259321 N7621MTorres Richard M · Valley Springs, CABuilt 1959 · S/N 55921 N7621TScheetz Wayne E · Center Point, IABuilt 1960 · S/N 47221 N7622APribyl Katie Ann Marie · Great Falls, MTBuilt 1956 · S/N 32519 N7622GBell Sky Pilots Inc · Reedley, CABuilt 1970 · S/N 17259322 N7622TFuhrman Chad L · Manchester, TNBuilt 1960 · S/N 47222 N7622XReale R Robert · Marblemount, WABuilt 1961 · S/N 17248122 N7623GPlane Sane Aero LLC · Cary, NCBuilt 1970 · S/N 17259323 N7623TMooney Micheal E · Auburn, INBuilt 1960 · S/N 47223 N7623VGove Richard · Riverside, CAFirst renewal noticeBuilt 1976 · S/N 177RG0892 N7623XDorman David L · Garfield, MNBuilt 1960 · S/N 17248123 N7624GAeroflight Flying Club Inc · Jackson, TNBuilt 1970 · S/N 17259324 N7624TAir & Opportunity Aviation LLC · Yorktown, VABuilt 1960 · S/N 47224 N7626AMissaukee Aircraft Leasing LLC · Cadillac, MIBuilt 1956 · S/N 32523 N7626TKoch Suzanne Elizabeth · Battle Ground, WABuilt 1960 · S/N 47226 N7627AMullin Samuel J · Salem, ORBuilt 1956 · S/N 32524 N7627XFindley Michael A · Moreland, GAS/N 17248127 N7628MSobutka John C · Hampton Falls, NHBuilt 1959 · S/N 55928 N7628XZintz Michael S · Centerville, IABuilt 1960 · S/N 17248128 N7629GDodd Dennis R · Collinsville, OKBuilt 1970 · S/N 17259329 N7629TBork Joseph L · Masier, ORS/N 47229 N7629XNeu Aviation LLC · Benton, LABuilt 1960 · S/N 17248129 N762JSSayers James B · Edison, OHBuilt 1981 · S/N A1520970 N762MAGiovannetti Peter C · Fond Du Lac, WIBuilt 1966 · S/N 15065187 N763United States Department Of Interior · Boise, IDBuilt 1986 · S/N U20606943 N7631GChickadee Aviation LLC · Rangeley, MEBuilt 1970 · S/N 17259331 N7631XCiccosanti John P · Kingston, NYBuilt 1960 · S/N 17248131 N7632XTrompeter Mark S · Intl Falls, MNBuilt 1960 · S/N 17248132 N7633XHillis Robert Duane · Utopia, TXBuilt 1960 · S/N 17248133 N7634MSutton Aircraft Salvage LLC · Palmer, AKBuilt 1959 · S/N 55934 N7636GDurham Ranches Inc · Gillette, WYBuilt 1970 · S/N 17259336 N7636MPorter Bryan A · Deer Lodge, MTBuilt 1959 · S/N 55936 N7636TN7636t LLC · Farmdale, OHBuilt 1960 · S/N 47236 N7637GEverett Flying Service Inc · Holly Grove, ARBuilt 1970 · S/N 17259337 N7637VRamsey Brian S · Monument, COBuilt 1976 · S/N 177RG0898 N7637XReddy Investments LLC · Contoocook, NHS/N 17248137 N7638GMoseley Michael S · Chelsea, ALBuilt 1970 · S/N 17259338

Back to AD 87-20-03 R2