Skip to content

Registered aircraft · 20,481

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:84-10-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:84-10-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:84-10-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:84-10-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:84-10-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:84-10-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.

N6372BCm Air LLC · Wilmington, DEBuilt 2004 · S/N 18281404 N6373BLee Kevin · Beulah, NDBuilt 1957 · S/N 34273 N6374KDls Holdings Inc · Lewes, DEBuilt 1979 · S/N 18053069 N6374NGeiger Roger W · Port Orchard, WAS/N 18267832 N6374TPlane Fun Inc Tr Trustee · Snellville, GAS/N R18202001 N6375BBarrientos Jeri D · Collinsville, OKBuilt 1957 · S/N 34275 N6376BMisty Blues Skydiving LLC · Highland, MIBuilt 1957 · S/N 34276 N6377EEnergy Transfer Aviation LLC · Spring, TXBuilt 1983 · S/N 18268363 N6377TTango Romeo Golf LLC · Wilmington, DES/N R18202003 N6379AReichlinger Gary · York, NEBuilt 1956 · S/N 33179 N6379BPittman William Greg · Anchorage, AKBuilt 1957 · S/N 34279 N637CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281532 N637RMOtn Skylane LLC · The Woodlands, TXBuilt 2012 · S/N 18282331 N6382AMuellner Peter M · Bigfork, MTBuilt 1956 · S/N 33182 N6383AGardner Frankie J · Mount Vernon, ARBuilt 1956 · S/N 33183 N6383BLewark Larry D · Frisco, COBuilt 1957 · S/N 34283 N6383CBurton Brandon · Canton, GABuilt 2004 · S/N 18281405 N6386CBas Part Sales LLC · Greeley, COS/N 21063879 N6388YMaclean Kenneth J · Northborough, MABuilt 1981 · S/N 21064359 N6389FSymms Fruit Ranch Inc · Caldwell, IDBuilt 1975 · S/N 18264185 N638CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281533 N6390BPalmer Bryce P · Chugiak, AKBuilt 1957 · S/N 34290 N6391TWebco Aviation LLC · Clay, KYBuilt 1985 · S/N R18202009 N6391UGimli Son LLC · Fort Lauderdale, FLBuilt 1979 · S/N U20605472 N63921Nc Division Of Marine Fisheries · Morehead City, NCBuilt 2004 · S/N 18281408 N6392ARlf Aviation LLC · Peachtree Corners, GABuilt 1956 · S/N 33192 N6392BHubatka Wilferd · Creston, IAFirst renewal noticeBuilt 1957 · S/N 34292 N6392CTretter Nicholas · Holden, MABuilt 1980 · S/N 21063880 N6392EWinds Aloft Inc · Lakeland, FLBuilt 1983 · S/N 18268366 N6392ZFlorence Michael · Portsmouth, NHBuilt 1981 · S/N U20606264 N6393ALadmill Investments LLC · Gulfport, MSBuilt 1956 · S/N 33193 N6393BLebard Racquele J · Sparks, NVBuilt 1957 · S/N 34293 N6394BPepitone David D · Santa Fe, NMS/N 57459 N6394DManzur Miguel Antonio · Mcallen, TXBuilt 1977 · S/N 21062010 N6394FScowden Wendell R · Piketon, OHBuilt 1975 · S/N 18264187 N6394SLincoln Air LLC · Kalispell, MTBuilt 1968 · S/N 182-59002 N6395ARose City Soaring Association Inc · Valdosta, GABuilt 1956 · S/N 33195 N6395BMb Laster Aviation LLC · Eagle, COBuilt 1957 · S/N 34295 N6395FSalisbury Neilan · Trabuco Canyon, CABuilt 1975 · S/N 18264188 N6395ZN Berk Consultant Inc · Greenwich, CTBuilt 1981 · S/N U20606266 N6396BGeezer Guys LLC · Eloy, AZBuilt 1957 · S/N 34296 N6396ELecrone Craig W · Duncansville, PAS/N 18268367 N6397BLayson Walter E · Calhoun, GABuilt 1978 · S/N 21062758 N6397FCrosby Dennis L · Foley, ALBuilt 1975 · S/N 18264189 N6397YAsher James A · Pasadena, CABuilt 1981 · S/N 21064363 N6398DAdx Holdings Lp · Marble Falls, TXS/N 18256755 N6398SInternational Air Services Inc Trustee · Carson City, NVS/N R18201670 N6398YSinglepoint Technologies Corp · Richmond, VABuilt 1981 · S/N 21064364 N6399AAllen Sam P · Poulsbo, WABuilt 1956 · S/N 33199 N6399T2f Trade LLC · Collinsville, TXBuilt 1985 · S/N R18202011

Back to AD 84-10-01 R1