Skip to content

Registered aircraft · 442

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:80-22-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:80-22-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:80-22-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:80-22-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:80-22-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:80-22-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.

N2361NBrewer Philip T · Bartlett, TNBuilt 1979 · S/N 38-79A0807 N2363NGeneral Aviation Support Corp · Rosamond, CANon-citizen corporation, flight hours not reportedS/N 38-79A0809 N2363PRoybal Jesse U · Kingman, AZBuilt 1979 · S/N 38-79A0963 N2364NNess Timothy J · Alexandria, MNBuilt 1979 · S/N 38-79A0810 N2365ADavedish LLC · South Fork, COBuilt 1978 · S/N 38-78A0657 N2365DSpurlock James D · Headland, ALBuilt 1978 · S/N 38-79A0284 N2368ETomasik John R · Lackawanna, NYS/N 38-78A0450 N2370BStrawberry Aviation Inc · Watsonville, CABuilt 1978 · S/N 38-79A0028 N2371LPiercy Brian K · San Anselmo, CABuilt 1979 · S/N 38-79A0733 N2372AOquinn Timothy M · Tehachapi, CABuilt 1978 · S/N 38-78A0661 N2372KKremer Charles A · Mckinney, TXS/N 38-79A0597 N23737Anderson Karl · Grant, ALS/N 38-79A1048 N23738Laureano Reynaldo · Murfreesboro, TNBuilt 1979 · S/N 38-79A1049 N2374LFrederick Calvin · Homestead, FLBuilt 1979 · S/N 38-79A0687 N2378BEssler Kim L · Garrison, NDBuilt 1978 · S/N 38-79A0029 N2378FPiper Aircraft Inc · Vero Beach, FLS/N 38-79A0409 N2379GDesselle Howard J III · Marksville, LAS/N 38-79A0509 N2379PHendrix Kim R · Cheboygan, MIBuilt 1979 · S/N 38-79A0970 N23800Adams Michael S · Huntsville, ALBuilt 1979 · S/N 38-79A1055 N2380KPiper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 38-79A0603 N2381KCarolinas Energy Associates LLC · Hays, NCBuilt 1979 · S/N 38-79A0605 N2381NHoyt Vance E Jr · Marina, CAS/N 38-79A0817 N2382VAnywhere Atp LLC · Mount Juliet, TNBuilt 1982 · S/N 38-82A0061 N23831Zekology LLC · Grayslake, ILS/N 38-79A1057 N2383FLaminar Aerospace LLC · Waukegan, ILBuilt 1978 · S/N 38-79A0411 N2385KHaynes Vincent L · Maumelle, ARBuilt 1979 · S/N 38-79A0610 N2386NHoelzle Paul R · Fremont, OHS/N 38-79A0820 N2387KClipper Properties LLC · Saratoga, WYBuilt 1979 · S/N 38-79A0833 N2388BN2388b LLC · Salem, ORBuilt 1978 · S/N 38-79A0031 N2388TSlatner John W · Sims, NCBuilt 1978 · S/N 38-78A0787 N2389DRowland James E Jr · Pennsville, NJFirst renewal noticeBuilt 1978 · S/N 38-79A0293 N2389FDavenport Jimmy J · Hayesville, NCBuilt 1978 · S/N 38-79A0413 N2389TForeman O Dean · Springfield, TNBuilt 1978 · S/N 38-78A0789 N23913Loop Timothy E · Orangevale, CABuilt 1979 · S/N 38-79A1064 N2392GPiper Aircraft Inc · Vero Beach, FLS/N 38-79A0513 N2393BReiley Hunter W · Harlingen, TXS/N 38-79A0035 N23945Sturgill Jerry R · Millers Creek, NCBuilt 1979 · S/N 38-79A1071 N2395BReed Kenneth P Jr · Roaring Spring, PABuilt 1978 · S/N 38-79A0037 N2397AKinkade Leslie D · Charlestown, INS/N 38-78A0668 N2398NWolf Aerospace Corp · Ontario, CAS/N 38-79A0824 N2401BArasmith Richard J · Sandy Valley, NVBuilt 1978 · S/N 38-79A0045 N2401FPiper Aircraft Inc · Vero Beach, FLBuilt 1978 · S/N 38-79A0417 N2402KHughes Travis · Willow Park, TXS/N 38-79A0618 N2403DKrella Russell · Batavia, ILBuilt 1978 · S/N 38-79A0294 N2403FClancy Timothy J · Bothell, WABuilt 1978 · S/N 38-79A0419 N2404TEverett Robert E Jr · Bogart, GABuilt 1978 · S/N 38-78A0793 N2406DAgerton William D Jr · Weatherford, TXBuilt 1978 · S/N 38-79A0296 N2406KHealdsburg Aviation Inc · Healdsburg, CABuilt 1979 · S/N 38-79A0619 N2407DChaney Eddie L · Douglas, GABuilt 1978 · S/N 38-79A0297 N2407PSterling Paul M · Goodyear, AZBuilt 1979 · S/N 38-79A0978

Back to AD 80-22-13