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.

N7936VFarrey Michael J · Mason, NHBuilt 1967 · S/N 18051836 N7937FSomes Brad H · Goddard, KSBuilt 1966 · S/N 15064037 N7937TTailwind Aviation Inc · Wasilla, AKBuilt 1960 · S/N 56637 N7937VSage Charles M Jr · Wasilla, AKBuilt 1967 · S/N 18051837 N7937ZWalters James G · Luthersville, GABuilt 1963 · S/N 15060037 N7938FPanik Kevin R · Titusville, FLS/N 15064038 N7938GDelaney Patrick James · Marion, TXBuilt 1970 · S/N 17259638 N7938UFearnow Rolland E · Wabash, INS/N 17251938 N7938VHayton James B · Sedro Woolley, WABuilt 1967 · S/N 18051838 N7938ZStenzel Michael R · Hamburg, IABuilt 1963 · S/N 15060038 N7939BChristmas Gabriel K · Fairbanks, AKBuilt 1956 · S/N 29739 N7939GMilton Alvah E II · Surrency, GABuilt 1970 · S/N 17259639 N7939THarris Kenneth L · Greeley, COS/N 56639 N7939VRuhl Daniel J · Bend, ORBuilt 1967 · S/N 18051839 N7939XCox Richard H III · Kapolei, HIBuilt 1961 · S/N 17248439 N7939ZSeibel Steven D · Wishek, NDBuilt 1963 · S/N 15060039 N793AKAcme Skywagon LLC · Idabel, OKFirst renewal noticeBuilt 1983 · S/N 18504409 N793DSDale Aviation LLC · Wilmington, DES/N 33701376 N793PTCappe Investment Group LLC · Homestead, FLBuilt 1975 · S/N 17263842 N79408Voorhees Charles Kirker · Tappahannock, VABuilt 1973 · S/N 18261816 N7940BHerbert Khristopher L · Tulsa, OKBuilt 1957 · S/N 29740 N7940FMile High Flight Club Inc · Miami, FLBuilt 1966 · S/N 15064040 N79410N79410 LLC · Tupelo, MSBuilt 1969 · S/N 17258061 N79412Talley William B · Bakersfield, MOBuilt 1969 · S/N 17258063 N79416Greene Tammy G · Alpharetta, GAS/N 17258067 N79417Lhotka Tim · Silver Lake, MNBuilt 1969 · S/N 17258068 N79418Lee Steven W · Somerset, KYBuilt 1969 · S/N 17258069 N7941BTetrahedron LLC · Layton, UTS/N 29741 N7941FLewis William J · Nashville, TNBuilt 1966 · S/N 15064041 N7941GPressley Aviation LLC · New London, NCBuilt 1970 · S/N 17259641 N7941TGoerger Allan E · Barney, NDS/N 56641 N7941XDixie Aerial Surveillance & Photography LLC · Heflin, LABuilt 1961 · S/N 17248441 N7941ZThiel David W · Independence, ORFirst renewal noticeBuilt 1963 · S/N 15060041 N79420Bas Part Sales LLC · Greeley, COBuilt 1969 · S/N 17258071 N79421Kauer Roy A · Millington, MIBuilt 1969 · S/N 17258072 N79424Mccutchan Anthony L · Collinsville, OKBuilt 1973 · S/N 18261818 N79425Legends Airways LLC · Lakeland, FLBuilt 1967 · S/N 15067734 N79428Mindset Dynamics LLC · Las Vegas, NVBuilt 1969 · S/N 17258077 N79429Hinds Community College · Bolton, MSBuilt 1969 · S/N 17258078 N7942BPuckett Jeffrey F · Rector, ARBuilt 1957 · S/N 29742 N7942GFlycarolina LLC · Rock Hill, SCBuilt 1970 · S/N 17259642 N7942TLinebaugh Ricky L · Dover, PABuilt 1960 · S/N 56642 N7942VKing Air Inc · Naknek, AKBuilt 1967 · S/N 18051842 N7942ZBrown David L · Hughesville, MOBuilt 1963 · S/N 15060042 N79431Brown Joshua W · Pomona, ILBuilt 1969 · S/N 17258080 N79432N7037g Inc · Wilmington, DEBuilt 1969 · S/N 17258081 N79434Gilpin Jeffrey · Portland, ORBuilt 1969 · S/N 17258083 N79435Pearce Gregory W · Eagle River, AKBuilt 1969 · S/N 17258084 N79436Granskog Gary L · Chico, CABuilt 1969 · S/N 17258085 N79439Asm Aviators LLC · Racine, WIBuilt 1973 · S/N 18261820

Back to AD 87-20-03 R2