Skip to content

Registered aircraft · 5,086

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:91-21-01-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:91-21-01-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:91-21-01-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:91-21-01-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:91-21-01-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:91-21-01-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.

N3231BEast Martin D · Nicholasville, KYBuilt 1974 · S/N 32-7540030 N32348Ramsey Time LLC · Winter Garden, FLBuilt 1974 · S/N 32-7540032 N3234LTarrant County College · Fort Worth, TXBuilt 1967 · S/N 27-3626 N32381Fritz John · Marlborough, CTBuilt 1974 · S/N 32-7540036 N32395Stuard Ronald R · Pittsburg, TXBuilt 1974 · S/N 32-7540037 N323DDHd Security Systems LLC · Watertown, TNBuilt 1981 · S/N 31-8152170 N323RFProtem Professionals LLC · Miller Place, NYBuilt 2001 · S/N 3257201 N32432Kg Elite Vacations LLC · Miami, FLBuilt 1974 · S/N 32-7540040 N3249RTappan Scott M · Port Saint Lucie, FLS/N 32-7140049 N324BKing Ag Leasing Inc · Sudan, TXBuilt 2005 · S/N T20608526 N324DSSpearing Dane R · Los Alamos, NMBuilt 1970 · S/N 32-40856 N324PATravaille Bernard W Trustee · Manteca, CABuilt 2001 · S/N 3257230 N324RRCentral Airlines Inc · Overland Park, KSBuilt 1964 · S/N 1386-139 N324RTTorres Rafael · Levittown, PRBuilt 1966 · S/N 27-3210 N32509Cherotation LLC · Guaynabo, PRBuilt 1974 · S/N 32-7540045 N32512Williams Clarence D · Charleston, MOBuilt 1974 · S/N 32-7540048 N3251GKrebs David A · Lubbock, TXBuilt 1980 · S/N 32R-8029044 N32523Heeringa Consruction LLC · Queen Creek, AZBuilt 1974 · S/N 32-7540046 N32570Nevil Aviation LLC · Statesboro, GABuilt 1974 · S/N 32-7540050 N32577Cooper Wayne R · Arcadia, FLBuilt 1974 · S/N 32-7540051 N325AKInternational Air Services Inc Trustee · Carson City, NVS/N 31-8112016 N325BBCapital City Curb & Gutter LLC · Wake Forest, NCBuilt 1975 · S/N 31-7512021 N325CRDiaz Aviation LLC · South New Berlin, NYBuilt 1978 · S/N 31-7912001 N325DSSchatz Douglas R · Winston Salem, NCBuilt 1974 · S/N 32-7540054 N325FATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1982 · S/N 31-8212005 N325JAdonai International Ministries · Marine, ILBuilt 1976 · S/N 31-7712002 N325MRDv Group LLC · Clovis, CABuilt 2004 · S/N 4636358 N325PAWelling Roger Trustee · Yorba Linda, CABuilt 2001 · S/N 3257237 N32600Goehl Jeffrey A · College Station, TXBuilt 1974 · S/N 32-7540052 N32655Brewer Gerald W · Sulphur Springs, TXBuilt 1974 · S/N 32-7540055 N326BPEagle Flew LLC · Sanford, NCBuilt 1974 · S/N 32-7540014 N326BWOlsen David A · Marinette, WIBuilt 1990 · S/N 109 N32706Strembicke Derek R · Owens Crossroads, ALBuilt 1974 · S/N 32-7540060 N32728Marianas Air Transfer Inc · Tinian, MPBuilt 1974 · S/N 32-7540061 N327HPN327hp LLC · Senoia, GABuilt 2000 · S/N 3257152 N327PLOcf Logistics LLC · Canyon, TXBuilt 1981 · S/N 32R-8229011 N327STBeach Cities Real Property Holdings LLC · Hermosa Beach, CABuilt 2005 · S/N T18208447 N32810Knoch Thomas James · Grass Valley, CABuilt 1974 · S/N 32-7540067 N328HPAlan C Perry LLC · Lake Charles, LABuilt 2000 · S/N 3257166 N32919Mbap LLC · Salt Lake City, UTS/N 32-7540074 N32934Robert Craig LLC · Wilmington, DEBuilt 1975 · S/N 32-7540075 N32998Clark Jeffrey Ryan · Greenville, KYBuilt 1975 · S/N 32-7540079 N329RSTeichman David · Dade City, FLBuilt 1963 · S/N 1303-118 N329SDAce Flight Center Inc · St Thomas, VIBuilt 1966 · S/N 27-3512 N32BVH Randal Brennan Pa · Vero Beach, FLBuilt 1972 · S/N 32-7240084 N32CGTaylor Group Architects Of California Inc · Fresno, CABuilt 1998 · S/N 27-0245 N32CZElk Mountain Rentals Inc · Waynesville, NCBuilt 2003 · S/N 3255011 N32MGPoor Boy Aero LLC · Seminole, TXBuilt 1982 · S/N 32R-8329003 N32PBLease One LLC · Lafayette, INBuilt 1981 · S/N 31-8212006 N32SBCook Robert W · Belair, MDBuilt 1976 · S/N 31-7612098

Back to AD 91-21-01 R1