Skip to content

Registered aircraft · 56,578

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.

N180XHigh Desert Land LLC · Rexburg, IDFirst renewal noticeBuilt 1959 · S/N 50485 N180XBChandler Christian J · Ashfield, MABuilt 1969 · S/N 18052008 N180XPAnders Jack H · Bend, ORBuilt 1956 · S/N 32494 N180XRBank Of Utah Trustee · Salt Lake City, UTBuilt 1954 · S/N 30743 N180XZGengenbach Joseph G · Livingston, TXBuilt 1964 · S/N 18051449 N180YKnudson Aviation LLC · Bozeman, MTBuilt 1962 · S/N 18051187 N180YHRobb Jon D · Alma, MIS/N 18051597 N180YPCrow Jack R · Bethel, AKBuilt 1964 · S/N 18051349 N180YSMontgomery Jeffrey · Lone Pine, CABuilt 1958 · S/N 51398 N180YYHastings Jamie · Vancouver, WAS/N 18052485 N180ZHenderson Ag Service Inc · Osceola, ARBuilt 1954 · S/N 30828 N180ZRLundell Don C · Los Altos, CABuilt 1955 · S/N 31662 N18100Liberty University School Of Aeronautics · Lynchburg, VABuilt 1972 · S/N 15073785 N18104Toth Stephen K · Northampton, PABuilt 1972 · S/N 15073788 N18108Larsen Kevin L · Firth, IDBuilt 1948 · S/N 18108 N18109Szoke Elliott · Mukilteo, WAS/N 15073792 N1810YLussier Lisa · Greene, RIFirst renewal noticeBuilt 1962 · S/N 17249410 N1810ZRanzway Corp · Seattle, WABuilt 1962 · S/N 2050010 N18110Radke Steven H · Hastings, MNBuilt 1972 · S/N 15073793 N18115Hinds Community College · Raymond, MSBuilt 1972 · S/N 15073796 N18118Bokman Charles J III · Athol, IDBuilt 1977 · S/N 18503328 N1811CEastburn Maurice H · Peyton, COBuilt 1953 · S/N 25955 N1811XAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1964 · S/N 18255911 N18126Harroun Charles G · Maryville, MOBuilt 1972 · S/N 15073804 N18129Loftics LLC · Kennewick, WABuilt 1976 · S/N 17702530 N1812EAtp Aircraft 6 LLC · Wilmington, DEBuilt 2018 · S/N 172S12168 N1812QLiv2fly LLC · Grand Junction, COBuilt 1975 · S/N U20602936 N1812RDriskell James P · Anchorage, AKBuilt 1974 · S/N 18502527 N1812XDavid Glen E · Ash Fork, AZS/N 18255912 N1812YHopkins Mark W · Emporia, KSBuilt 1962 · S/N 17249412 N18140Johnroe Ryan M · Mount Pleasant, MIBuilt 1972 · S/N 15073815 N18144Kachemak Bay Flying Service · Temple, TXBuilt 1972 · S/N 15073817 N18145Stlouis Aviation LLC · Miramar, FLBuilt 1972 · S/N 15073818 N1814FAlpine Cable And Construction Inc · Grand Junction, COBuilt 1965 · S/N 21058714 N1814VBeyer Leasing Co · Paw Paw, MIS/N 17263759 N18155Willis Nathan Eric · Broken Arrow, OKBuilt 1972 · S/N 15073828 N18157Matz Robert D · Niles, MIBuilt 1972 · S/N 15073830 N18159Beck Thomas G · Walled Lake, MIBuilt 1976 · S/N 17702534 N1815HPlane Fun Inc Tr Trustee · Snellville, GABuilt 1976 · S/N 21061148 N1815MReim Rodney D · Enid, OKBuilt 1971 · S/N 33701415 N1815ROsprey Island Lodge Inc · Eagle River, AKBuilt 1974 · S/N 18502530 N18162Pruzek Richard L · Chippewa Falls, WIBuilt 1972 · S/N 15073834 N18163Wings Aero LLC · Zeeland, MIBuilt 1972 · S/N 15073835 N18164Cendejas Agustin · Chino, CABuilt 1972 · S/N 15073836 N18167Be Chara Niz Ar E · Columbia, MDBuilt 1972 · S/N 15073838 N1816CCalvert Tobin R · San Antonio, TXBuilt 1953 · S/N 25960 N1816FMalcom Scott O · Toledo, WABuilt 1965 · S/N 21058716 N1816JWakefield Aircraft LLC · Cooperstown, NDS/N 182-68574 N1816QS And E Airplane Company · Puyallup, WABuilt 1971 · S/N 177RG0216 N1816RArizona Game & Fish Dept · Phoenix, AZBuilt 1974 · S/N 18502531

Back to AD 79-10-14 R1