Skip to content

Registered aircraft · 25,369

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:80-25-07-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-25-07-R1') 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:80-25-07-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-25-07-R1')
  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:80-25-07-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-25-07-R1')
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.

N81SMSchwartz Grantham L · Garden City, TXBuilt 2005 · S/N 1402-2005 N81TPPowers Charles M · Greenwood, MSBuilt 1979 · S/N 210-63426 N81XMNoble Gary D · Sioux Falls, SDBuilt 1964 · S/N 2727 N8200GRj Vincent Enterprises LLC · Rancho Santa Fe, CABuilt 1971 · S/N 177RG0100 N8201ABeggs Daniel · Royston, GABuilt 1978 · S/N 24-0603 N8201BTammi Mark K · Grass Valley, CABuilt 1978 · S/N 24-0604 N8201GMetzgen Richard A · Groveland, CABuilt 1971 · S/N 177RG0101 N8201QEhmka Mitchell · Lombard, ILBuilt 1978 · S/N 24-0606 N8201XPotter Jan Charles · Tangerine, FLBuilt 1978 · S/N 24-0609 N8203GWarne Samuel S · Salisbury, NCBuilt 1971 · S/N 177RG0103 N8204GLowe Clinton V · Lake Point, UTBuilt 1971 · S/N 177RG0104 N8207GKing Paul · Mount Holly, NJBuilt 1971 · S/N 177RG0107 N8208EChamplain Island Hoppers · Burlington, VTBuilt 1979 · S/N 17272153 N8208GAerialscapes Inc · Hartland, WIBuilt 1971 · S/N 177RG0108 N8209GJames Billy J II · Comfort, TXBuilt 1971 · S/N 177RG0109 N820SDBachman Ryan · Mesa, AZFirst renewal noticeBuilt 1998 · S/N 820-98 N8211GSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1971 · S/N 177RG0111 N8212GDavis Richard M · Southport, NCBuilt 1971 · S/N 177RG0112 N82149Sanders Flight Training Center Inc · Jasper, ALBuilt 1976 · S/N 17267692 N8214GKolman Michael D · Overland Park, KSBuilt 1971 · S/N 177RG0114 N8215GGersten Iron · Spring Valley, CABuilt 1971 · S/N 177RG0115 N8216GFarrar Edwin L · Mansfield, OHBuilt 1971 · S/N 177RG0116 N8219GSchaum Jerome B · Machipongo, VABuilt 1971 · S/N 177RG0119 N821SDGlobal Adventures N821sd LLC · Hollywood, FLBuilt 1985 · S/N 172-76485 N8221GIshoy Glen · Indiana, PABuilt 1971 · S/N 177RG0121 N8224GSkylarkers Inc · Farmington, NMBuilt 1971 · S/N 177RG0124 N8225YInternational Air Services Inc Trustee · Carson City, NVFirst renewal noticeBuilt 1977 · S/N 177RG1247 N8227GKritz Eric J · Gualala, CABuilt 1971 · S/N 177RG0127 N8229GEastman Gary Lynn · Penn Valley, CABuilt 1971 · S/N 177RG0129 N822CGRepublic Wings LLC · Moseley, VABuilt 1976 · S/N 177RG1031 N822ESouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1966 · S/N 990 N822LMLehberger Charles W · Madison, CTBuilt 1979 · S/N R18201081 N822MLMojo Flight Group LLC · Gainesville, GABuilt 1975 · S/N 17265684 N822MWPilie Louis J · Grand Island, NYBuilt 1975 · S/N 174-75 N822TTRobinson Donald S · Underwood, NDS/N 351-72 N822VAffection Above Aviation Inc · Yukon, OKBuilt 1978 · S/N 1281-79 N8231GRad Pouria · Camarillo, CABuilt 1971 · S/N 177RG0131 N8235GSterling Colleen M Trustee · El Cajon, CABuilt 1971 · S/N 177RG0135 N8236GVinton Timothy R · Whitman, NEBuilt 1979 · S/N 17273618 N8237GRegistered aircraftBuilt 1971 · S/N 177RG0137 N8238GDavison Dennis D · Spanaway, WABuilt 1971 · S/N 177RG0138 N823SPUberti Christopher · Brighton, MIBuilt 1976 · S/N 24-0003 N8241GSilvers Clarence W III · Holden, MOBuilt 1971 · S/N 177RG0141 N8242GValdez Acela Rangel · Maricopa, AZS/N 177RG0142 N8243EMacon Air LLC · Franklin, NCBuilt 1979 · S/N 17272155 N8243GGebauer David Lee · Jackson, CABuilt 1971 · S/N 177RG0143 N8244GHughes Jeffrey D · Roseburg, ORBuilt 1971 · S/N 177RG0144 N8245GSchultz Jeffrey R · Dayton, OHBuilt 1971 · S/N 177RG0145 N8248GSchuster Peter E · Dundee, OHBuilt 1971 · S/N 177RG0148 N824FFly Well Flying Club Inc · Roseville, MNBuilt 1977 · S/N R18200022

Back to AD 80-25-07 R1