Skip to content

Registered aircraft · 56,580

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

N41MEFlydreams Aircraft Group Inc · Fort Lauderdale, FLBuilt 1978 · S/N 17269389 N41MQParsons Douglas L · Carrollton, OHBuilt 1978 · S/N 18266506 N41MTX2nsat Inc · Petaluma, CABuilt 1977 · S/N 18265725 N41RMK & M Aviation LLC · West Liberty, KYBuilt 1951 · S/N 19808 N41TXHase Gary A · Fort Worth, TXBuilt 1954 · S/N 26396 N41WPSale Reported · Copper Center, AKSale reported, pending cancellationS/N 15068019 N41YYSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1980 · S/N 21063653 N42002Kuntz Jonathan W · Yorktown, VABuilt 1968 · S/N 18258801 N42004Haskell Airport Inc · Coweta, OKBuilt 1999 · S/N 18280446 N42006Thompson Jeffrey L · Scandia, KSBuilt 1968 · S/N 18258804 N42007Southeastern Oklahoma State University · Durant, OKBuilt 1999 · S/N 17280744 N4200FVanhorne John W · Everett, WABuilt 1958 · S/N 46100 N4200LDewey Michael C · Deer Island, ORBuilt 1966 · S/N 17254269 N4200UPereira Jesse C · Medford, ORBuilt 1963 · S/N 15060200 N42016Roush Everett Wayne · Forsyth, GAS/N 18258810 N4201QReeve Ryan · Hurricane, UTBuilt 1971 · S/N 17260101 N42020Brewster Matthew L · Chico, CABuilt 1968 · S/N 18258812 N42024White Wings Air Inc · Jacksonville, FLBuilt 1974 · S/N 17264153 N42025Stokes Clive V · Gilbert, AZBuilt 1972 · S/N 18052301 N42026Bains Jordan John W · Anchorage, AKBuilt 1972 · S/N 18052302 N42027Dehart Dee Y · Payson, UTBuilt 1968 · S/N 18258818 N4202LAa-Aero LLC · Fairfield, NJBuilt 1999 · S/N 17280747 N4202QWings Over Texas Holdings LLC · Denton, TXBuilt 1971 · S/N 17260102 N4202UVlk Mark J · Odessa, WABuilt 1963 · S/N 15060202 N42033State Of Alaska · Anchorage, AKBuilt 1974 · S/N 17264154 N42035Paulsen Hans J · Cedartown, GABuilt 1974 · S/N 17264155 N42036Murphy Steven R · Aguila, AZBuilt 1968 · S/N 18258822 N4203FWindham Air LLC · Oxford, FLBuilt 1958 · S/N 46103 N4203PHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1999 · S/N 17280748 N4203QWings Over Texas Holdings LLC · Denton, TXBuilt 1971 · S/N 17260103 N4203UZeller Vernon B · Boonville, MOBuilt 1963 · S/N 15060203 N4203VAmelia Reid Aviation LLC · Wilton, CABuilt 1948 · S/N 18559 N42041Armenia John Robert · Land O Lakes, FLBuilt 1968 · S/N 18258825 N42042N1622f LLC · Grand Prairie, TXS/N 18258826 N42044Van Beusekom Brian T · Loretto, MNBuilt 1968 · S/N 18258828 N42045Jones Daryn W Trustee · Sumpter, ORBuilt 1968 · S/N 18258829 N42049King Ronald E · Englewood, FLBuilt 1968 · S/N 18258830 N4204FStephani Timothy M · White Lake, WIS/N 46104 N4204LMarquis Kim R · Poplar Bluff, MOBuilt 1966 · S/N 17254273 N42051Flying M Aviation Inc · Irondale, ALBuilt 1972 · S/N 18052305 N42053Jewett Clinton Baxter Trustee · Colusa, CABuilt 1968 · S/N 18258832 N42055Klp Aeromotive LLC · Morriston, FLBuilt 1973 · S/N 18052306 N42058State Of North Carolina · Raleigh, NCBuilt 1998 · S/N 18280441 N4205FMunoz Randy · Aledo, TXBuilt 1958 · S/N 46105 N4205LKay Bennie L · Brigham City, UTBuilt 1966 · S/N 17254274 N4205UCentral California Soaring Association Inc · Avenal, CABuilt 1963 · S/N 15060205 N42060Satathite Will J · Soldotna, AKBuilt 1968 · S/N 18258835 N42061Muhle Gerald A · Lincoln, NEBuilt 1974 · S/N 17264156 N42062Parker Jo K Trustee · Ardmore, OKBuilt 1974 · S/N 17264157 N42063Bailey Danny R · China Grove, NCBuilt 1968 · S/N 18258838

Back to AD 79-10-14 R1