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.

N2668UMid South Aircraft Inc · Gadsden, ALBuilt 1963 · S/N 17250268 N2668VPlane Fun Inc Tr Trustee · Snellville, GABuilt 1948 · S/N 18178 N2669FMichelbrink Hunter J · Gardiner, MTS/N 18256769 N2669LRotormate LLC · Royse City, TXBuilt 1967 · S/N 17255869 N2669QBanks Ron E · Blanchard, OKBuilt 1966 · S/N 18257869 N2669RStrubhar Wesley D · Foster, ORBuilt 1967 · S/N 18258369 N2669SWilliams Kent A Jr · Kissimmee, FLBuilt 1968 · S/N 337-0969 N2669VMartin Brian J · Grayslake, ILBuilt 1948 · S/N 18179 N2669XSkydive Ricks LLC · Petersburg, OHBuilt 1965 · S/N P206-0169 N2669YHession Mark A · Arrington, TNBuilt 1962 · S/N 18051169 N266LARaintree Aviation LLC · Mesa, AZBuilt 2012 · S/N 172S11178 N266MEGershman Randy · Marshfield, WIBuilt 2000 · S/N 18280772 N266SPTfs Air LLC · Loveland, COBuilt 2003 · S/N 172S9471 N266TATextron Aviation Inc · Wichita, KSS/N 18283365 N266VFox Stephen A · Wasilla, AKBuilt 1954 · S/N 31215 N2670DBoggess William C · Placerville, CABuilt 1952 · S/N 20822 N2670JMiw Airmen Inc · Marshalltown, IABuilt 1966 · S/N 15065670 N2670LOns Bart · Kirkland, WABuilt 1967 · S/N 17255870 N2670VRetro Air LLC · Seattle, WABuilt 1948 · S/N 18180 N2670YErickson Wesley B · Littleton, COBuilt 1962 · S/N 18051170 N2671JSherman Phillip A · Mansfield, OHBuilt 1966 · S/N 15065671 N2671LNbl Aviation LLC · Woodway, TXBuilt 1967 · S/N 17255871 N2671RCw Equipment Rentals Inc · Biggs, CABuilt 1967 · S/N 18258371 N2671UMetz Thomas H · Mifflintown, PABuilt 1963 · S/N 17250271 N2672FWright James F · Glenford, OHS/N 18256772 N2672GPhillips Douglas S · Gloversville, NYBuilt 1959 · S/N 51972 N2672MSchmoll Aviation LLC · Sterling, AKBuilt 1966 · S/N 18051729 N2672SJja Transportation LLC · Springville, UTBuilt 1968 · S/N 337-0972 N2672UBender John Lowell Trustee · N Richland Hills, TXBuilt 1963 · S/N 17250272 N2672VWhite Robe · Castro Valley, CABuilt 1974 · S/N 177RG0649 N2672XBird Nest Aviation LLC · Sheldon, IABuilt 1998 · S/N 18280305 N2672YSchmieding Michael · Salem, ORBuilt 1962 · S/N 18051172 N2673GChapman Chad · San Antonio, TXBuilt 1959 · S/N 51973 N2673JWest David V · Sandusky, OHBuilt 1966 · S/N 15065673 N2673LBalcom Terry J · Shepherd, MIBuilt 1967 · S/N 17255873 N2673RDouville Laura Deluea · Portland, ORBuilt 1967 · S/N 18258373 N2673SWilliams Randall S · Chico, CABuilt 1976 · S/N 21061348 N2673UBonin Patrick G · Blossvale, NYBuilt 1963 · S/N 17250273 N2673VJackson R N · Southlake, TXBuilt 1974 · S/N 177RG0650 N2673ZFiske James K · North Andover, MABuilt 1963 · S/N 185-0673 N2674DKnefley Michael · Ulysses, PABuilt 1952 · S/N 20826 N2674LValley Excavation And Grading Inc · Chatsworth, CABuilt 1967 · S/N 17255874 N2674VMoroil Corp · Davidson, NCBuilt 1974 · S/N 177RG0651 N2674XKaiser Eric J · Milford, INBuilt 1966 · S/N P206-0174 N2675DPaige Barry Wayne · Wasilla, AKBuilt 1952 · S/N 20827 N2675FVarnado Matthew G · Denham Springs, LABuilt 1965 · S/N 18256775 N2675LFoster Jeffrey W · Lexington, NCBuilt 1967 · S/N 17255875 N2675RDotzenroth David A · Watertown, MNS/N 185-02392 N2675UAv Hawk Aviation LLC · Montclair, NJS/N 17250275 N2675VHartis Christopher · Newman Lake, WABuilt 1948 · S/N 18185

Back to AD 79-10-14 R1