Skip to content

Registered aircraft · 3,193

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:77-13-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:77-13-21') 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:77-13-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:77-13-21')
  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:77-13-21')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:77-13-21')
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.

N7807YMcv2021 LLC · Saint Augustine, FLBuilt 1965 · S/N 30-886 N7808YKleiner Daniel S · Aliso Viejo, CABuilt 1965 · S/N 30-887 N780ACSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1969 · S/N 301967 N7810PCompass Aviation LLC · Lagrange, GABuilt 1962 · S/N 24-3030 N7811PLitz Mark C · Mission Viejo, CABuilt 1962 · S/N 24-3031 N7815YPinhoc Inc · Winter Garden, FLBuilt 1965 · S/N 30-747 N7817PGoff Mark A · Grand Blanc, MIBuilt 1962 · S/N 24-3037 N7818PJohnson Herbert A · Evart, MIBuilt 1962 · S/N 24-3038 N7818YCooney Daniel E · Wrightwood, CABuilt 1965 · S/N 30-895 N7819YCobabe Ronald Bruce · Boerne, TXBuilt 1965 · S/N 30-896 N7820PCowlin Nathan · Hollywood, SCBuilt 1961 · S/N 24-2665 N7820YComa Pipe LLC · Wilmington, DEBuilt 1965 · S/N 30-897 N7821PTucker Engineering Associates Inc · Locust, NCS/N 24-3040 N7822PTrue Airspeed Aviation LLC · Albany, GABuilt 1962 · S/N 24-3041 N7826YInternational Air Services Inc Trustee · Carson City, NVS/N 30-800 N7827PRowan Christopher James · Sparks, NVBuilt 1962 · S/N 24-3047 N7827YEpton Richard Charles · Senoia, GABuilt 1965 · S/N 30-902 N7828PBvv Aviation LLC · Ben Wheeler, TXBuilt 1962 · S/N 24-3048 N7828YVan Laak James E · Poquoson, VAS/N 30-903 N7829PSpring Mountain Technologies LLC · Schwenksville, PABuilt 1962 · S/N 24-3049 N7830YGospel Ministries International Inc · Mc Donald, TNBuilt 1965 · S/N 30-906 N7832PInternational Air Services Inc Trustee · Carson City, NVBuilt 1962 · S/N 24-3052 N7833BAnderson Bryan C · Arlington, TNBuilt 1959 · S/N 24-952 N7833PPeters Jakob G · Tempe, AZS/N 24-3053 N7834PRegistered aircraftBuilt 1962 · S/N 24-3054 N7834YBall Half Out LLC · Mesa, AZBuilt 1965 · S/N 30-911 N7835YRegistration Pending · Lewes, DERegistration pendingBuilt 1965 · S/N 30-912 N7836PKearney Kory · Papillion, NEBuilt 1962 · S/N 24-3056 N7837PMobbd LLC · Vero Beach, FLS/N 24-3057 N7840YArno Philip A · Clarence Center, NYBuilt 1965 · S/N 30-920 N7842PFall Stuart W · Holland, MIBuilt 1962 · S/N 24-3065 N7844PTroy Watson Consulting Inc · Muleshoe, TXBuilt 1962 · S/N 24-3067 N7845PRawlins Everett R · Pedro, OHBuilt 1962 · S/N 24-3068 N7848PJads Airplane Club LLC · Boyne City, MIBuilt 1962 · S/N 24-3071 N7852YBordlemay John J · Lewisberry, PABuilt 1965 · S/N 30-932 N7855YParrish Aviation Flight Academy LLC · Southlake, TXBuilt 1965 · S/N 30-936 N7856YEastern Technical Corp · Martinsburg, WVBuilt 1965 · S/N 30-937 N7858YGraham Stuart H · Heath, OHBuilt 1965 · S/N 30-778 N7860PValley Aircraft Management Inc · Visalia, CABuilt 1962 · S/N 24-3083 N7861PSparks James R · Maxwelton, WVBuilt 1962 · S/N 24-3085 N7861Y7861y LLC · Long Beach, CAS/N 30-942 N7862YSteiger Michael P · Cypress, TXBuilt 1965 · S/N 30-944 N7863PMicheletti Joe A · Lake Almanor, CABuilt 1962 · S/N 24-3088 N7863YSlipshod Aviation LLC · Hurricane, UTBuilt 1965 · S/N 30-945 N7864YVavra Loren · Phoenix, AZFirst renewal noticeBuilt 1965 · S/N 30-946 N7865PGear Down Hangar LLC · Phoenix, AZBuilt 1962 · S/N 24-3090 N7865YMussman Craig L · Grant Park, ILBuilt 1965 · S/N 30-948 N7866PGcsb Enterprises LLC · Oklahoma City, OKBuilt 1963 · S/N 24-3091 N7866YHenrie Aviation LLC · Fairfield, NJBuilt 1965 · S/N 30-949 N7871YDow Jeff W · Port Hadlock, WAS/N 30-955

Back to AD 77-13-21