Skip to content

Registered aircraft · 17,027

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

N7007SJw Air Ventures LLC · New Smyrna Beach, FLBuilt 1967 · S/N 15067707 N7008SPoe John B · Port Orange, FLS/N 15067708 N7009QJoiner Legacy Enterprises LLC · Joliet, MTS/N 17260309 N700CDCrahen William F · Merrimac, WIBuilt 1975 · S/N 177RG0788 N700PJShort Stephen A · Lake Placid, NYBuilt 1977 · S/N 17702628 N7010GStavair LLC · Gulf Breeze, FLBuilt 1969 · S/N 17258710 N7010QMosman Matthew J · Nezperce, IDS/N 17260310 N7011FGlow Medspa LLC · Spring Hill, TNS/N 15063611 N7011GChase Development Aviation LLC · Oakland Park, FLBuilt 1969 · S/N 17258711 N7013GSaeid Abdelmasih · Euless, TXBuilt 1969 · S/N 17258713 N7013QVeil Casey J · Jamestown, NDBuilt 1971 · S/N 17260313 N7014ESkinner Norman D · Osceola, IABuilt 1964 · S/N 21058334 N7015GDaugherty William A · Horseheads, NYBuilt 1969 · S/N 17258715 N7016SCreed Stephen L · Hamilton, VABuilt 1967 · S/N 15067716 N7017QClair Michael A · Omaha, TXFirst renewal noticeBuilt 1971 · S/N 17260317 N7017SGladwin Stephen R · Pflugerville, TXBuilt 1967 · S/N 15067717 N7018GCape Aerial Tours Inc · Chatham, MABuilt 1969 · S/N 17258718 N7018QStockett & Assoc Ltd · Hattiesburg, MSBuilt 1971 · S/N 17260318 N7019FShore Luke S · Thurmond, NCS/N 15063619 N7019QYenser Thomas A · Kutztown, PABuilt 1971 · S/N 17260319 N701DZSkydive Fargo Inc · West Fargo, NDFirst renewal noticeBuilt 1965 · S/N 18256501 N7020QAufderheide Flying Service Inc · De Witt, ARBuilt 1971 · S/N 17260320 N7021SMountainhawk Leasing LLC · Nampa, IDBuilt 1968 · S/N 15067721 N7022QChant Savanah B · Baggs, WYBuilt 1971 · S/N 17260322 N7023GCunningham Kieran G · Newport, RIBuilt 1973 · S/N 15074608 N7024QWells Nathan S · Scotia, NEBuilt 1971 · S/N 17260324 N7027QAero B Flying Service · Richards, MOBuilt 1971 · S/N 17260327 N7027SRed Cessna Aviation LLC · West Valley City, UTS/N 15067727 N7028GKathol Donavin J · Hartington, NEBuilt 1969 · S/N 17258728 N7028QBurns Michael S · Coplay, PABuilt 1971 · S/N 17260328 N7029SWright Flyers LLC · Fayetteville, GABuilt 1967 · S/N 15067729 N702BDaly Moses M · Underhill, VTS/N U206-1279 N702DZSkydive Fargo Inc · West Fargo, NDBuilt 1966 · S/N P206-0152 N702GTsiouklas Aviation Inc · Dunedin, FLBuilt 1968 · S/N 17256919 N7030FPaul William · Windfall, INBuilt 1966 · S/N 15063630 N7030SAcoba Dylan Anthony · Orangevale, CABuilt 1967 · S/N 15067730 N7031SBurns Randall A · Rogers, ARBuilt 1967 · S/N 15067731 N7032STamayo Ernest R · Dripping Springs, TXS/N 15067732 N7034GFat Tyre Flyers LLC · Moses Lake, WABuilt 1969 · S/N 17258734 N7034QTesch David P · Pardeeville, WIBuilt 1971 · S/N 17260334 N7035QEarly Bird Aviation LLC · Phoenix, AZBuilt 1971 · S/N 17260335 N7037GN7037g Inc · Newark, DEBuilt 1969 · S/N 17258737 N7037QJohnson Joe N · Smithville, TNBuilt 1971 · S/N 17260337 N7038GRoeder Blaine W · El Prado, NMBuilt 1973 · S/N 15074609 N7038QSchenone William M · Mattituck, NYBuilt 1971 · S/N 17260338 N7039FWharam Glen A · Park River, NDBuilt 1966 · S/N 15063639 N7039GWood Donna L · Wisconsin Dells, WIBuilt 1973 · S/N 15074610 N703ZSibert Gerald R · Tacoma, WABuilt 1971 · S/N 18260582 N7040FVtf LLC · Winter Haven, FLBuilt 1966 · S/N 15063640 N7040QOrlandi Properties LLC · Blairstown, NJBuilt 1971 · S/N 17260340

Back to AD 72-03-03 R3