Skip to content

Registered aircraft · 56,580

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.

N3277JBranson William E · Stokesdale, NCBuilt 1966 · S/N 15065977 N3277LDeshpande Peter N · Eugene, ORBuilt 1967 · S/N 17256177 N3277SBayless Smoky · Coronado, CABuilt 1964 · S/N 18255777 N3277YLapinsky Richard G · Los Lunas, NMBuilt 1962 · S/N 18254277 N3278JSarrafi Frank H · Tarzana, CABuilt 1966 · S/N 15065978 N3278LPeterson Donald A · Ajo, AZBuilt 1967 · S/N 17256178 N3278SStrong Brian S · Southport, NCBuilt 1964 · S/N 18255778 N3278UCarver Thomas G · St Maries, IDBuilt 1963 · S/N 18254678 N3278VMathison John · Vancouver, WABuilt 1974 · S/N 15076448 N3279DDavies James E · Eagle, IDBuilt 1955 · S/N 32077 N3279LDomnarski Michael J · Ware, MABuilt 1967 · S/N 17256179 N3279NTips Frederick J III · San Antonio, TXBuilt 1974 · S/N 21060452 N3279USchlafmann Jay R · Mercer, NDBuilt 1963 · S/N 18254679 N327BWCessna N327bw LLC · Telluride, COBuilt 1974 · S/N 21060166 N327CTYr-Aircraft Leasing LLC · Bethel, AKBuilt 1979 · S/N 20700535 N327DMMullin Clint · Lambert, MTS/N 18262924 N327GHTextron Aviation Inc · Wichita, KSS/N 18283369 N327HRRd Holdings LLC · Las Vegas, NVBuilt 1979 · S/N 18267468 N327JKRudolph Rudi · Cordova, TNBuilt 1976 · S/N R1722003 N327KMarsh John E · Washington, DCS/N 185 0418 N327LSHeermann Philip D · Albuquerque, NMBuilt 1978 · S/N 182-66407 N327LWPerini Stephen Dale · Fayetteville, GABuilt 1959 · S/N 52360 N327SPAmeriflyers Of Texas Inc · Addison, TXBuilt 1999 · S/N 172S8254 N32806Nimsic Thomas L · Carson City, NVBuilt 1976 · S/N 18264943 N3280LDobbertin Thomas E · Redlands, CAS/N 17256180 N3281DRichardson John David · Willis, TXBuilt 1955 · S/N 32079 N3281JRegistration Pending · Oakland, ORRegistration pendingBuilt 1966 · S/N 15065981 N3281LWizna LLC · Boca Raton, FLBuilt 1967 · S/N 17256181 N3281SWright Flyers Club · Huber Heights, OHBuilt 1964 · S/N 18255781 N3282DLafleur Kerry P · Fort Worth, TXBuilt 1955 · S/N 32080 N3282LFranco David F Jr · Santa Rosa, CABuilt 1967 · S/N 17256182 N3282SWest Thomas Edward · Watsonville, CABuilt 1964 · S/N 18255782 N3282TCavu Aircraft Sales & Management Inc · Olyphant, PABuilt 1967 · S/N 17700582 N3283AHarrison Donald R · Lake Havasu City, AZBuilt 1953 · S/N 25927 N3283DAllen Roger B · Gardnerville, NVBuilt 1955 · S/N 32081 N3283LHill Suzanne L · Edmond, OKBuilt 1967 · S/N 17256183 N3284DKornfield Edward A · Anchorage, AKBuilt 1955 · S/N 32082 N3284LWill Clifford S · Grayson, GABuilt 1967 · S/N 17256184 N3284YMonnin Cass C · East Wenatchee, WAS/N 18254284 N3285LDouglass Grant · Rockport, TXBuilt 1967 · S/N 17256185 N3285SCastro Manny H · Tucson, AZBuilt 1964 · S/N 18255785 N3285VAviate Navigate Communicate LLC · Dewey, AZBuilt 1977 · S/N R1722245 N3286JJohnson David W · Biwabik, MNS/N 15065986 N3286LEagle Eye Aviation LLC · Meridian, IDBuilt 1967 · S/N 17256186 N3287ASpetman Craig Warren · Overgaard, AZS/N 25931 N3287EOff Course Aero Ventures LLC · Mechanicsville, VABuilt 1978 · S/N 17271492 N3288Mewmew Investment II LLC · Palo Alto, CABuilt 2020 · S/N 172S12430 N3288ABaeten Gerard J · De Pere, WIBuilt 1953 · S/N 25932 N3288DSmith James O · Montgomery, TXS/N 32086 N3288JSouthern Arkansas University Tech · Camden, ARBuilt 1966 · S/N 15065988

Back to AD 79-10-14 R1