Skip to content

Registered aircraft · 1,642

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

N32381Fritz John · Marlborough, CTBuilt 1974 · S/N 32-7540036 N32394Cherokee Wings LLC · Indialantic, FLBuilt 1974 · S/N 32-7500005 N32395Stuard Ronald R · Pittsburg, TXBuilt 1974 · S/N 32-7540037 N323DTEaton Professionals Inc · Charlotte, MIBuilt 1977 · S/N 32-7740024 N32432Kg Elite Vacations LLC · Miami, FLBuilt 1974 · S/N 32-7540040 N3248WKeifer Ronald C · Port Orange, FLBuilt 1965 · S/N 32-66 N3249RTappan Scott M · Port Saint Lucie, FLS/N 32-7140049 N3249WMountain West Aviation LLC · Albuquerque, NMBuilt 1965 · S/N 32-67 N324DSSpearing Dane R · Los Alamos, NMBuilt 1970 · S/N 32-40856 N324TSDes Moines Flying Club LLC · Indianola, IABuilt 1966 · S/N 32-841 N32509Cherotation LLC · Guaynabo, PRBuilt 1974 · S/N 32-7540045 N32512Williams Clarence D · Charleston, MOBuilt 1974 · S/N 32-7540048 N32523Heeringa Consruction LLC · Queen Creek, AZBuilt 1974 · S/N 32-7540046 N3254WKelley James · Mena, ARBuilt 1965 · S/N 32-76 N3255WPridmore Joseph P · Columbus, MSBuilt 1965 · S/N 32-77 N32570Nevil Aviation LLC · Statesboro, GABuilt 1974 · S/N 32-7540050 N32577Cooper Wayne R · Arcadia, FLBuilt 1974 · S/N 32-7540051 N3258WDiaz Andy · Kansas City, MOBuilt 1965 · S/N 32-81 N325DSSchatz Douglas R · Winston Salem, NCBuilt 1974 · S/N 32-7540054 N32600Goehl Jeffrey A · College Station, TXBuilt 1974 · S/N 32-7540052 N3261WParish Ora Nichols · Martinez, GABuilt 1965 · S/N 32-85 N32655Brewer Gerald W · Sulphur Springs, TXBuilt 1974 · S/N 32-7540055 N326BPEagle Flew LLC · Sanford, NCBuilt 1974 · S/N 32-7540014 N326DPSiemer William S · Labelle, FLBuilt 1967 · S/N 32-854 N32706Strembicke Derek R · Owens Crossroads, ALBuilt 1974 · S/N 32-7540060 N32728Marianas Air Transfer Inc · Tinian, MPBuilt 1974 · S/N 32-7540061 N3272WTownsend Douglas W · Charlotte, NCBuilt 1965 · S/N 32-102 N32785Registration Pending · Kodiak, AKRegistration pending, pending cancellationBuilt 1974 · S/N 32-7500009 N3278WEvans Jacob · Mona, UTBuilt 1965 · S/N 32-109 N32810Knoch Thomas James · Grass Valley, CABuilt 1974 · S/N 32-7540067 N3283WGlasgow Ronnie Kyle Jr · Guin, ALS/N 32-114 N3284WLower James A · Greenville, MIBuilt 1965 · S/N 32-115 N3289WShandon Aviation LLC · Lewes, DES/N 32-122 N32919Mbap LLC · Salt Lake City, UTS/N 32-7540074 N3292WOldenkamp Daryl · Hermosa Beach, CAS/N 32-125 N32934Robert Craig LLC · Wilmington, DEBuilt 1975 · S/N 32-7540075 N3295WChapman Daniel H Jr · Ontario, CABuilt 1965 · S/N 32-128 N32998Clark Jeffrey Ryan · Greenville, KYBuilt 1975 · S/N 32-7540079 N3299WLowe Russell · Navarre, FLS/N 32-133 N32BVH Randal Brennan Pa · Vero Beach, FLBuilt 1972 · S/N 32-7240084 N32BZManganaro John G II · Manvel, TXBuilt 1973 · S/N 32-7300014 N32RFPulford Robert A · Barkhamsted, CTBuilt 1978 · S/N 32-7800001 N32VTWinging It LLC · Louisville, KYBuilt 1979 · S/N 32-7940029 N33009Pamrus Inc · Zephyr Cove, NVS/N 32-7540080 N3302WKsnl Aero LLC · Shawnee, OKBuilt 1965 · S/N 32-137 N3305WSalisch Jurgen · Napoleon, OHS/N 32-141 N33076Takagishi Hideto · San Jose, CABuilt 1975 · S/N 32-7540084 N3307WCowell Samuel · Easley, SCBuilt 1965 · S/N 32-144 N33089Double Ll Enterprises LLC · Virginia Beach, VABuilt 1975 · S/N 32-7540086 N330PCaldaso Inc · Peachtree City, GABuilt 1978 · S/N 32-7840164

Back to AD 74-18-13