Skip to content

Registered aircraft · 8,920

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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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.

N782LULiberty University School Of Aeronautics · Lynchburg, VABuilt 2014 · S/N 4496372 N782NDFox Leasing Group LLC · Hollywood, FLBuilt 2016 · S/N 4496397 N7830YGospel Ministries International Inc · Mc Donald, TNBuilt 1965 · S/N 30-906 N78329Tindall William M · Pensacola, FLS/N 27-2329 N7832DCamp Barry G · Lafayette, LAS/N 22-5478 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 N7839DMartin David · Jackson, GABuilt 1957 · S/N 22-5489 N783LKPullis Troy K · Hutchinson, MNBuilt 1959 · S/N 22-6900 N783LULiberty University School Of Aeronautics · Lynchburg, VABuilt 2015 · S/N 4496381 N783NDVertol Systems Company Inc · Destin, FLBuilt 2016 · S/N 4496398 N7840DDavis Steven T · Colleyville, TXBuilt 1957 · S/N 22-5490 N7840YArno Philip A · Clarence Center, NYBuilt 1965 · S/N 30-920 N7842BLowe David M · Sacramento, KYBuilt 1956 · S/N 23-632 N7842DCasler Robert A · Phelps, NYBuilt 1957 · S/N 22-5492 N7842PFall Stuart W · Holland, MIBuilt 1962 · S/N 24-3065 N7844PTroy Watson Consulting Inc · Muleshoe, TXBuilt 1962 · S/N 24-3067 N7845DParr Richard · Pittsboro, NCBuilt 1957 · S/N 22-5495 N7845PRawlins Everett R · Pedro, OHBuilt 1962 · S/N 24-3068 N7846DDrake Lewis · Murray, KYS/N 22-5496 N7847DBuckner John L · Ragland, ALBuilt 1957 · S/N 22-5497 N7848DChurchill Maverick B · Alliance, NES/N 22-5498 N7848PJads Airplane Club LLC · Boyne City, MIBuilt 1962 · S/N 24-3071 N784LULiberty University School Of Aeronautics · Lynchburg, VABuilt 2016 · S/N 4496396 N7850DPunt Matthew L · Wasilla, AKBuilt 1957 · S/N 22-5500 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 N7857DHeinze Bill · Ashley, MIBuilt 1957 · S/N 22-5507 N7858DRegistration Pending · Raleigh, NCRegistration pendingBuilt 1957 · S/N 22-5508 N7858YGraham Stuart H · Heath, OHBuilt 1965 · S/N 30-778 N7859DMurray Craig W · Raymond, WABuilt 1957 · S/N 22-5509 N785LULiberty University · Lynchburg, VABuilt 2018 · S/N 4496433 N785NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2016 · S/N 4496399 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

Back to AD 85-02-05 R1