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.

N2128EFly For Fun LLC · Rockville, MDBuilt 1978 · S/N 17271165 N2128GBeckhoff Michael A · Casper, WYBuilt 1958 · S/N 51428 N2128RCreasey Daniel L · Arnold, MOBuilt 1964 · S/N 18255328 N21291Castleair LLC · Dothan, ALBuilt 1972 · S/N 18261542 N21295Tauscher Robert C · Friday Harbor, WABuilt 1974 · S/N 17263925 N21297Bradley Robert S M Sr · Rougemont, NCBuilt 1972 · S/N 18261545 N21299L-Bird LLC · Hood River, ORBuilt 1967 · S/N 337-M0005 N2129CFlot Group LLC · Apex, NCBuilt 2003 · S/N 172S9436 N2129DLoadholtz Heath T · Watford City, NDBuilt 1965 · S/N 18256143 N2129FStewart Madison F Co Persona Representative · Broken Arrow, OKBuilt 1965 · S/N U206-0329 N2129JRidgeline Assets LLC · Wilmington, DEBuilt 2003 · S/N 172S9441 N2129QEarnshaw Larry L · Erie, COBuilt 1974 · S/N 177RG0529 N2129YEdwards Air LLC · Raleigh, NCBuilt 1962 · S/N 17249629 N212AFDoolittle Aero LLC · Goodyear, AZS/N 15076277 N212ANCalifornia In Nice Inc · San Jose, CABuilt 1981 · S/N 17274432 N212BGRegistered aircraftBuilt 1980 · S/N 172RG0195 N212BSEuros Aircraft Leasing LLC · College Station, TXBuilt 1999 · S/N 172S8243 N212CCChristenson Charles F · Auburn, WABuilt 1966 · S/N 18257852 N212CFWest Coast Equipment Leasing LLC · Englewood, COBuilt 1998 · S/N 17280418 N212DARegistration Pending · Phoenix, AZRegistration pendingBuilt 1972 · S/N U20601901 N212GBSooner Farms LLC · Siloam Springs, ARBuilt 1975 · S/N 21061130 N212KTLanier Howard W · Willis, TXS/N P206-0349 N212PMEllisor Don · Grapeland, TXBuilt 1966 · S/N 337-0527 N212SWRarden Matthew W · Albuquerque, NMBuilt 1979 · S/N 18266842 N212TMSchuldt Scott A · North Little Rock, ARBuilt 1968 · S/N 17701004 N212TSParkside Automotive & Truck Service · Mountain Top, PABuilt 1980 · S/N 21064214 N212WLPeace Jiles V · Easley, SCBuilt 1976 · S/N 18265082 N21302Blackburn James E · Upland, CAS/N 18261549 N2130FSilverhawk Aviation Academy LLC · Caldwell, IDBuilt 2003 · S/N 172S9419 N21310Bagnell Enterprises LLC · Anaconda, MTBuilt 1972 · S/N 18261552 N21315Clinical Anatomy Associates Inc · Mason, OHBuilt 1972 · S/N 18261556 N21316Bohnert Jason F · Harrisonville, MOBuilt 1972 · S/N 18261557 N21317Mathes Richard A · Byron, NYBuilt 1972 · S/N 18261558 N2131ATru Flight Materials LLC · Wilmington, DEBuilt 2005 · S/N 18281649 N2131FHerschberger Glen M · Willow, AKBuilt 1964 · S/N U206-0331 N2131QImhoff Donald W · Baton Rouge, LABuilt 1974 · S/N 177RG0531 N2131RCapriccio Leasing LLC · Tigard, ORBuilt 1964 · S/N 182-55331 N2131UAgh Property Investments Inc · Key West, FLBuilt 2003 · S/N 18281227 N2131XBrown Jerry D · Rockport, TXS/N 337-0031 N2131ZAllen Travis · Newport, MEBuilt 1982 · S/N 18268165 N21320Diehl Rodney L Trustee · San Jose, CABuilt 1974 · S/N 17263929 N21321Bell Robert A · Las Vegas, NVBuilt 1974 · S/N 17263930 N21326Ttf Flying LLC · Anderson, SCBuilt 2007 · S/N 18281897 N21328Endler Harold A · Black Mountain, NCBuilt 1972 · S/N 18261563 N21329Propeller Enterprises LLC · Gilbert, AZBuilt 1974 · S/N 17263931 N2132FHitchcock Wayne · Shelbyville, TNBuilt 1964 · S/N U206-0332 N2132QHawk Aviation Inc · Chesapeake Beach, MDBuilt 1974 · S/N 177RG0532 N2132RSifsof Victor G DBA · Anchorage, AKBuilt 1964 · S/N 18255332 N2132WWheeler Equipment Leasing LLC · Gainesville, GABuilt 2003 · S/N 172S9421 N21331J-Air Eagle LLC · San Antonio, TXBuilt 2007 · S/N 18281898

Back to AD 79-10-14 R1