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.

N2351YToes In The Sand LLC · Bentonville, ARBuilt 1967 · S/N 17700151 N23521Aircraft Holdings LLC · Missoula, MTBuilt 1998 · S/N 18280418 N2352BGwyn Farms Inc · Moses Lake, WABuilt 1998 · S/N 18280416 N2352CMcmahan Johana · Gakona, AKBuilt 1953 · S/N 30652 N2352DOptima Aviation LLC DBA · Lewisville, TXBuilt 1952 · S/N 20504 N2352MCloud Cap Technology · Hood River, ORBuilt 1999 · S/N 18280417 N2352RElkhorn Aviation LLC · Mandan, NDBuilt 1964 · S/N 18255452 N2353COverly Terrence Lee · Tok, AKBuilt 1953 · S/N 30653 N2353DJensen Carl V · Raleigh, NCBuilt 1952 · S/N 20505 N2353GCascade Aero LLC · Scotts Mills, ORS/N 51653 N2353KGraff Lars U · Kohler, WIBuilt 1998 · S/N 18280420 N2353USelman Charles D · Pflugerville, TXS/N 17249953 N2354CMoma Donald R · Wasilla, AKBuilt 1953 · S/N 30654 N2354DRegistered aircraftBuilt 1952 · S/N 20506 N2354EGaruda Flight Training LLC · Miami, FLBuilt 1979 · S/N 172-72777 N2354GJbtg LLC · Poplar Bluff, MOBuilt 1958 · S/N 51654 N2354RCarter Bradford J · Rockland, MEBuilt 1964 · S/N 18255454 N2354SSkymaster Stc LLC · Mena, ARBuilt 1967 · S/N 337-0654 N2354XNorth Coast Aeronautical LLC · Cleveland, OHBuilt 1965 · S/N 18256254 N23556Aerospring Leasing LLC · Wasilla, AKBuilt 2005 · S/N 172S10095 N23557Flying Dutchman LLC · Wilmington, DEBuilt 2005 · S/N 172S10096 N2355CFerguson Edward P · Fargo, NDBuilt 1953 · S/N 30655 N2355DWest Coast Aerosport Inc · Dove Canyon, CAS/N 20507 N2355EAce Of Spades Aviation LLC · Las Vegas, NVFirst renewal noticeBuilt 1978 · S/N 17271248 N2355RLima Mike Inc · Ham Lake, MNBuilt 1964 · S/N 18255455 N2355XVan Every Jason E · Cleburne, TXBuilt 1965 · S/N 18256255 N2355YSchwarz Enterprises LLC · Huntington Beach, CABuilt 1967 · S/N 17700155 N2356Dunn Cole E · Florala, ALBuilt 1973 · S/N 17261946 N23566Sunrise Aviation Inc · Ormond Beach, FLBuilt 2005 · S/N 172S10097 N2356DKirsipuu Paul W · Voluntown, CTBuilt 1952 · S/N 20508 N2356EHock Aviation LLC · Stuart, FLBuilt 1999 · S/N 18280423 N2356GKajans Donald F · Reno, NVBuilt 1958 · S/N 51656 N2356LCircle B Pipe & Supply LLC · Odessa, TXBuilt 1998 · S/N 18280425 N2356RBledsoe Charles J · Jackson, GABuilt 1964 · S/N 18255456 N2356UPanko Jeffrey A · Lusby, MDS/N 17249956 N2357FBachand Kevin L · Leesburg, VABuilt 1964 · S/N 21058557 N2357XScavera Kevin · Madras, ORBuilt 1965 · S/N 18256257 N23581So Cal Leasing LLC · El Cajon, CABuilt 1998 · S/N 17280595 N2358DStofer William · Warsaw, INS/N 20510 N2358EAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 17250725 N2358FEast County Communications Inc · Hurricane, UTBuilt 1965 · S/N 21058558 N2358URegistration Pending · Cave Creek, AZRegistration pendingBuilt 1962 · S/N 17249958 N2359FSheldon David E Trustee · Idaho Falls, IDBuilt 1964 · S/N 21058559 N2359RTide City Air LLC · Germantown, TNBuilt 1964 · S/N 18255459 N2359XHarker Charles R · Suwanee, GABuilt 1965 · S/N 18256259 N2359YWadsworth Edwin Allen · Sarasota, FLBuilt 1967 · S/N 17700159 N235CACivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13084 N235EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2023 · S/N 172S13099 N235HLBeach Norman G Jr · Newman, CABuilt 1978 · S/N 18266526 N235HP235hp LLC · Norwood, NCBuilt 1998 · S/N 18280333

Back to AD 79-10-14 R1