Skip to content

Registered aircraft · 40,395

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:79-10-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:79-10-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:79-10-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:79-10-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:79-10-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:79-10-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.

N1702EExecutive Flight Institute LLC · Murrieta, CABuilt 1978 · S/N 17271101 N1702HHesston College · Hesston, KSBuilt 1977 · S/N 28-7790336 N1702VClassic Rotors Museum · Ramona, CABuilt 1974 · S/N 17263717 N1703JCogan Betty C · Bristol, TNBuilt 1968 · S/N 28-24111 N1703PCastillo Stephen P · San Antonio, TXBuilt 1954 · S/N 22-2490 N1703TAlicea Ismael · Iselin, NJBuilt 1970 · S/N 28-7125019 N17049101 Inc · Bejou, MNBuilt 1976 · S/N 17702497 N1704TLavieri Gary P · Seneca, SCBuilt 1970 · S/N 28-7125020 N17050Findlow Jerry E · Glasser, NJBuilt 1976 · S/N 17702498 N17052Skypilot LLC DBA · Benbrook, TXBuilt 1976 · S/N 17702499 N1705JPeel William · Gilbert, AZBuilt 1968 · S/N 28-24113 N1705TLubeski Lawrence J · Lapeer, MIBuilt 1970 · S/N 28-7125021 N1705VNiles Air LLC · Concord, NCBuilt 1974 · S/N 17263718 N17068Adamski Thomas R · Grantham, NHBuilt 1976 · S/N 17702501 N1706BWagstrom Wayne A · Aurora, UTFirst renewal noticeS/N 12-1562 N1706JSkycastle Flying Club Inc · New Castle, INBuilt 1968 · S/N 28-24114 N1706TMarshall Loraine · Independence, KYS/N 28-7125022 N17079Speakman Donna M · Auburn, ALBuilt 1965 · S/N 28-2157 N1707TMoore Merritt T II · Silver Creek, NYBuilt 1955 · S/N 23-299 N17080Van Wagner Aerial Media LLC · Hollywood, FLBuilt 1959 · S/N 18-7196 N1708PRaymond Harrison Donald · Camp Verde, AZBuilt 1954 · S/N 22-2495 N1708TN1708t Owners Assn · Chesapeake, VABuilt 1970 · S/N 28-7125023 N17091Martin Stanley B · Lockhart, TXBuilt 1976 · S/N 17702502 N1709JWingman Unlimited LLC · Carrollton, TXBuilt 1968 · S/N 28-24118 N170AWAir Alaska Properties · Wasilla, AKBuilt 1955 · S/N 26805 N170FGs Aviation Inc · Stilwell, KSBuilt 1952 · S/N 25149 N170MFSymphony Aircraft Leasing LLC · Fort Lupton, COS/N 0017 N170SKNottingham John F · Covington, LABuilt 1979 · S/N 17273173 N170SPSweatt Jeffrey · West Terre Haute, INBuilt 1981 · S/N 17275097 N170TDHoyt Nicholas J · Port Orchard, WABuilt 1954 · S/N 26488 N170WTBarber Shane C · Willow, AKS/N 12-753 N17102North Timothy · Milton, WVBuilt 1976 · S/N 17702503 N1710JOpen Skies Aviation LLC · Wellington, KSBuilt 1968 · S/N 28-24119 N1710TGarretson Thomas A · New Smyrna Beach, FLBuilt 1970 · S/N 28-7125025 N1711DSterling Douglas J · Hadley, NYBuilt 1999 · S/N 5230 N1712JTwelvejuliet LLC · Moberly, MOBuilt 1968 · S/N 28-24123 N1712QMischief Makers LLC · Tuscaloosa, ALBuilt 1971 · S/N 15073012 N1712TLea Joe A · Mason City, IABuilt 1970 · S/N 28-7125026 N17137Miller Scott · Albia, IABuilt 1976 · S/N 17702506 N1713JSimpson Mark E · Fairbanks, AKBuilt 1968 · S/N 28-24124 N1713VGrasshopper Flying Club · Poughkeepsie, NYBuilt 1974 · S/N 17263721 N1714210ds Ltd · Centreville, VABuilt 1976 · S/N 17702507 N1714JFernandes Gary DBA · Clallam Bay, WABuilt 1968 · S/N 28-24126 N1716JNess Brian · Wasilla, AKBuilt 1968 · S/N 28-24128 N1716PJones Gary L · Kerrville, TXBuilt 1954 · S/N 22-2506 N1716TStratus Business Development LLC · Nashua, NHBuilt 1970 · S/N 28-7125030 N1717Nelson Jeffrey V · Westfield, INBuilt 1981 · S/N 5431521 N17172Tohidi Karen A · North Las Vegas, NVBuilt 1976 · S/N 17702508 N17173Dunbar Michael C · Cedar Falls, IABuilt 1976 · S/N 17702509 N17177Dawn Patrol Flying Club · Northville, MIBuilt 1976 · S/N 17702510

Back to AD 79-10-03 R2