Skip to content

Registered aircraft · 81,728

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

N32441Registration Pending · Kalispell, MTRegistration pendingS/N 28-7505060 N32444Jtz Aviation LLC · Wilmington, DEBuilt 1974 · S/N 28R-7535057 N3244BSharon Enterprises LLC · Peralta, NMBuilt 1954 · S/N 22-2074 N3244FKempton Brian J · Huntsville, TXBuilt 1967 · S/N 670037 N3244MNeill Robert & Neill Bonnie · Holly, COBuilt 1947 · S/N 12-1898 N3244TCaicedo Oscar E · Garner, NCS/N 17700544 N3244ZGinn Robert Theron · Royston, GABuilt 1959 · S/N 22-7191 N32452Watkins Nathan · Baytown, TXBuilt 1974 · S/N 28-7510022 N3245CArmstrong Bruce · Port Orchard, WABuilt 1982 · S/N HC-01882 N3245QTandy Richard L · North Chili, NYBuilt 1974 · S/N 28-7515159 N3245RA & W Cattle Co · Flippin, ARBuilt 1969 · S/N 28R-31019 N32462Av8 Flight Services LLC · Wichita Falls, TXBuilt 1974 · S/N 28-7515162 N32466Oh Heung Taeg · Olney, MDBuilt 1974 · S/N 28-7505062 N32469Dufresne Justin Barth · Temple City, CABuilt 1974 · S/N 28R-7535059 N3246TFears Edwin G III · Trafalgar, INBuilt 1967 · S/N 17700546 N32475Eikenberry Don A · Palouse, WABuilt 1974 · S/N 28-7525072 N32478Sidney Aviation LLC · Sidney, NEBuilt 1974 · S/N 28-7515164 N3247FWilliams Matthew D · Xenia, OHS/N 670040 N3247RArrowood Bradley W · Winston Salem, NCBuilt 1970 · S/N 28R-31111 N3247TBeeda Mark A · West Palm Beach, FLBuilt 1967 · S/N 17700547 N32480Alphakiloecho LLC · Somerville, MABuilt 1974 · S/N 28-7505063 N32481Flyboy Fantasy Inc · South Lake Tahoe, CABuilt 1974 · S/N 28R-7535061 N32483Showah Jason M · Brentwood, TNBuilt 1974 · S/N 28R-7535062 N32486Parr Bobbie D · Mount Pleasant, TXBuilt 1974 · S/N 28-7515167 N32488Registered aircraftBuilt 1974 · S/N 28-7515168 N3248BAgaliotis Paul E · San Martin, CAS/N 22-2078 N3248MGautreau Peter · Chickaloon, AKBuilt 1947 · S/N 12-2103 N3248PAero Spectra Corp · Boulder, COS/N 23-1193 N3248WKeifer Ronald C · Port Orange, FLBuilt 1965 · S/N 32-66 N32490Jackson Charles A · Winchester, KYBuilt 1974 · S/N 28-7515169 N32492Doyle Dylan D · Cerrillos, NMBuilt 1974 · S/N 28R-7535063 N3249FRoberto Jeffrey M · Piscataway, NJBuilt 1967 · S/N 670042 N3249WMountain West Aviation LLC · Albuquerque, NMBuilt 1965 · S/N 32-67 N324ALauridsen Hans O · Scottsdale, AZFirst renewal noticeS/N 9962CC N324AKKeiser John T · Santa Fe, NMBuilt 2018 · S/N CC19-0041 N324CFerris Ryan P · Rochester, NYBuilt 1999 · S/N 374-320-129 N324CPCivil Air Patrol · Maxwell Afb, ALBuilt 2018 · S/N 172S12135 N324CSBrush Country Helicopters LLC · Laredo, TXBuilt 2013 · S/N 2321 N324DBDaugherty Warren F Jr · Jonestown, PABuilt 1956 · S/N 324 N324DHWood Thomas E · Sherrills Ford, NCBuilt 1979 · S/N AA5B1259 N324DNFluckey Craig · Plattsmouth, NEBuilt 2003 · S/N 80820-001 N324GIsle Air LLC · Danbury, CTBuilt 1995 · S/N 3246003 N324MARollings Hills Aviation Inc · Pelham, GABuilt 2002 · S/N 1330-2002 N324PTPlanedocs LLC · Spearfish, SDBuilt 2007 · S/N 40081 N324RPClear For Take Off LLC · Burlingame, CABuilt 2004 · S/N 18281422 N324RVAmsa Jet Crew Solutions LLC · Windermere, FLFirst renewal noticeBuilt 1998 · S/N 24895 N324SVDavis Kyle R · Colleyville, TXBuilt 1980 · S/N R18201609 N324TKiser Garald · Christiana, TNS/N 18-2438 N324TAIslander Holdings Ltd · Fort Lauderdale, FLBuilt 1980 · S/N 892 N324TSDes Moines Flying Club LLC · Indianola, IABuilt 1966 · S/N 32-841

Back to AD 81-18-04 R2