Skip to content

Registered aircraft · 20,683

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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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.

N702VPCaribbean Air Partners LLC · Winter Garden, FLBuilt 1964 · S/N 17251373 N7030AStuckle Eugene A · Davenport, WABuilt 1956 · S/N 29130 N70323Sky Equity LLC · Woodbury, MNBuilt 1976 · S/N 17267200 N7032ARobinson Michael D · Folkston, GABuilt 1956 · S/N 29132 N7033AWalter Aviation LLC · Bradenton, FLS/N 29133 N7033TTimm Alan W · Hettinger, NDS/N 46633 N70340Wings Over Texas Holdings LLC · Denton, TXBuilt 1976 · S/N 17267203 N7034GFat Tyre Flyers LLC · Moses Lake, WABuilt 1969 · S/N 17258734 N7034QTesch David P · Pardeeville, WIBuilt 1971 · S/N 17260334 N7035AMcgavock Edward A · Columbus, WIBuilt 1956 · S/N 29135 N7035QEarly Bird Aviation LLC · Phoenix, AZBuilt 1971 · S/N 17260335 N7036AMachuga James A · Davis, CABuilt 1956 · S/N 29136 N70376Sawyer Gregory T · Olga, WABuilt 1976 · S/N 17267206 N70378Vertol Systems Company Inc · Destin, FLBuilt 1976 · S/N 17267207 N7037GN7037g Inc · Newark, DEBuilt 1969 · S/N 17258737 N7037QJohnson Joe N · Smithville, TNBuilt 1971 · S/N 17260337 N70380Mindy Ltd LLC · Muscatine, IABuilt 1976 · S/N 17267208 N70386Johnson Ben A · Gainesboro, TNS/N 17267209 N7038QSchenone William M · Mattituck, NYBuilt 1971 · S/N 17260338 N70392Gateway Flying Club Inc · Blaine, MNBuilt 1976 · S/N 17267211 N703BFTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13488 N703BKKenzy 2023 LLC · Castle Rock, COBuilt 2023 · S/N 172S12991 N703LULiberty University · Lynchburg, VABuilt 2014 · S/N 172S11387 N703SPFlightline LLC · Lewes, DEBuilt 1985 · S/N 172-76443 N703VPCaribbean Air Partners LLC · Winter Garden, FLBuilt 1963 · S/N 17250823 N7040QOrlandi Properties LLC · Blairstown, NJBuilt 1971 · S/N 17260340 N7040TLesko Shannon Lt · Loves Park, ILBuilt 1959 · S/N 46640 N70411Charlie Lima 1 LLC · Jacksonville, FLBuilt 1976 · S/N 17267216 N70413Lake Elmo Aero LLC · Lake Elmo, MNBuilt 1976 · S/N 17267217 N70416Mcgee David · West Monroe, LAS/N 17267218 N7041AOfarrell Scott T · Seattle, WABuilt 1956 · S/N 29141 N7041GJohnson Justin Eric · Grand Forks, NDBuilt 1969 · S/N 17258741 N7041QElizabeth City State University · Elizabeth City, NCBuilt 1971 · S/N 17260341 N7042AGuilbert Gerald L Jr · Fairfax, VABuilt 1956 · S/N 29142 N7042G7042g LLC · Shingle Springs, CAS/N 17258742 N7042QWatts Ruiz LLC · Waco, TXBuilt 1971 · S/N 17260342 N7043QNelson Christopher J · Hayfield, MNBuilt 1971 · S/N 17260343 N7044ABradley Shannon C · Carrsville, VABuilt 1956 · S/N 29144 N7044GSpitzbart David G · Woodstock, ILBuilt 1969 · S/N 17258744 N7045TDougherty Peter G · Yakima, WABuilt 1959 · S/N 46645 N7047TPetersen Derrick D · Sibley, IABuilt 1959 · S/N 46647 N7048QFirelight Academy LLC · Brush, COBuilt 1972 · S/N 17260348 N7048THenegar Robert A · Newhope, ARFirst renewal noticeBuilt 1959 · S/N 46648 N70493Starnes Michael A · Murfreesboro, TNBuilt 1976 · S/N 17267220 N7049ATjernjund Wesley Gordon · Salem, ORBuilt 1956 · S/N 29149 N7049GLouisville Aircraft Leasing LLC · Louisville, KYS/N 17258749 N7049QVortex Aero LLC · Lakeland, FLBuilt 1972 · S/N 17260349 N704LULiberty University · Lynchburg, VABuilt 2014 · S/N 172S11425 N704RBAirway Equipment Leasing LLC · Alpharetta, GABuilt 2004 · S/N 172S9657 N7050AMccollum Devin S · Flagstaff, AZS/N 29150

Back to AD 90-06-03 R1