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.

N15538Schwartz David · Lakeland, FLBuilt 1972 · S/N 32-7300009 N15551Buchanan Jennings R · Cocoa Beach, FLBuilt 1972 · S/N 32-7300010 N15552Crate Inc · Humboldt, NEBuilt 1972 · S/N 32-7340048 N15554Hogan James · Winter Garden, FLBuilt 1972 · S/N 32-7340014 N1556XMills Donald Lee · Arlington, TNBuilt 1975 · S/N 32-7540124 N15646Smith Michael S · Norman, OKBuilt 1972 · S/N 32-7300012 N156XN156x LLC · Fayetteville, GABuilt 1978 · S/N 32-7840156 N15708Lanza Thomas N · Las Vegas, NVBuilt 1972 · S/N 32-7340058 N1572EKorkmaz Fethi A · Asheville, NCS/N 32-7340059 N1575XMaring Thomas J · Westley, CABuilt 1975 · S/N 32-7540178 N15776Rc & C Inc · Norwalk, IABuilt 1972 · S/N 32-7340064 N15788Chafin Gerald III · Mountain Home, ARS/N 32-7300016 N1583XK&T Lawn & Landscape Inc · Newport News, VABuilt 1975 · S/N 32-7540179 N15895Ksgj Aircraft LLC · Saint Augustine, FLBuilt 1972 · S/N 32-7340072 N1591XTask Aviation LLC · Vancouver, WABuilt 1975 · S/N 32-7540180 N15939Ray H Gregg · Nashville, GABuilt 1973 · S/N 32-7300021 N15961Kings Wings · Jupiter, FLBuilt 1973 · S/N 32-7300022 N16253Quincy Aircraft LLC · Quincy, ILS/N 32-7340080 N16269Kelley John Charles · Hot Springs Ntl, ARBuilt 1973 · S/N 32-7340081 N16332Brown Chritopher M · Lake Helen, FLBuilt 1973 · S/N 32-7300023 N16372Blue Bird Aviation LLC · Zephyr Cove, NVBuilt 1973 · S/N 32-7340083 N16378Lapair Inc · Vero Beach, FLBuilt 1973 · S/N 32-7300026 N16396Nobrainer Holdings LLC · Fort Lauderdale, FLBuilt 1973 · S/N 32-7300027 N16415United Aviation LLC · Prospect, KYS/N 32-7340085 N1643HSiegenthaler Dean · Mineral Point, WIBuilt 1977 · S/N 32-7700011 N164412c Fun Aviation LLC · Dallas, TXBuilt 1973 · S/N 32-7340087 N16487Piper Cherokee LLC · Seal Beach, CABuilt 1973 · S/N 32-7340090 N16498Owens Hay LLC · Crane, ORBuilt 1973 · S/N 32-7340091 N164LLSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1966 · S/N 32-714 N164ULariviere Jeffrey A · Douglassville, PABuilt 1967 · S/N 32-996 N16542Marianas Air Transfer Inc · Saipan, MPS/N 32-7340093 N166CBStar Ground Services Inc · Tinian, MPBuilt 1973 · S/N 32-7440032 N166NGVaught Timothy A · Mauldin, SCBuilt 1975 · S/N 32-7500016 N166RBMf Plane Management LLC · Wesley Chapel, FLBuilt 1974 · S/N 32-7440138 N1673HTronerud Jason · Maple Grove, MNBuilt 1977 · S/N 32-7740037 N16ABMasselink Ross W · Whitewater, KSBuilt 1967 · S/N 32-40245 N17286Pride Terence E · Columbia, TNS/N 32-40899 N173SNWilliams Hoffman Alexander M · Downers Grove, ILBuilt 1967 · S/N 32-912 N176WBVincent David R · Hartley, TXBuilt 1976 · S/N 32-7600013 N178MCWillett Cattle Co · Sanford, COBuilt 1973 · S/N 327340178 N17MCMaplecross Wealth Management LLC · Cookeville, TNBuilt 1968 · S/N 32-40523 N17MDMoyer David · Katy, TXBuilt 1966 · S/N 32-552 N1804HBl&B LLC · Knoxville, TNBuilt 1977 · S/N 32-7700012 N18311Begay & Away LLC · Houston, TXS/N 32-40092 N1860HNighthawks Sanity LLC · Chesterfield, MOBuilt 1977 · S/N 32-7740043 N188ABSafford Aviation Service Inc · Coolidge, AZBuilt 1969 · S/N 32-40884 N18BRFly Ohio Inc · Columbus, OHBuilt 1966 · S/N 32-371 N190PHJohnson Cameron M · Worthington, MNBuilt 1977 · S/N 32-7740064 N1918TThompson Todd · Elmore, MNBuilt 1971 · S/N 32-7140060 N1953HBritton Scott M · Fairview, TXBuilt 1977 · S/N 32-7740044

Back to AD 74-18-13