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.

N2932QK & W Aviation LLC · Jackson, TNBuilt 1977 · S/N 32-7740055 N2947ESlipstream Inc · Saint Petersburg, FLBuilt 1979 · S/N 32-7940222 N2947UDickenson Scott · Montgomery, TXBuilt 1979 · S/N 32-7940226 N2951XMonsalve Zauris J · Coconut Creek, FLFirst renewal noticeS/N 32-7940227 N2957NBak John A · Lake Forest, CABuilt 1979 · S/N 32-7940228 N2957RBantle Aviation LLC · Midlothian, VABuilt 1979 · S/N 32-7940229 N2960YHudson Maury B · Humble, TXBuilt 1979 · S/N 32-7940230 N2965APa 32 LLC · Union Center, WIBuilt 1979 · S/N 32-7940236 N2967QPowell Samuel C · Burlington, NCBuilt 1979 · S/N 32-7940243 N2969QOsullivan James S · Palo Alto, CABuilt 1977 · S/N 32-7740056 N296AREnvation LLC · Winter Haven, FLBuilt 1977 · S/N 32-7840063 N2989MInternational Air Services Inc Trustee · Carson City, NVBuilt 1977 · S/N 32-7840062 N2DPGreat Circle Flying Club Inc · Sandusky, OHBuilt 1973 · S/N 32-7340112 N2SBMarz Richard F · Statesboro, GABuilt 1973 · S/N 32-7440011 N3001PN3001p LLC · Aurora, OHBuilt 1979 · S/N 32-7940045 N3001XTerrebonne Aviation Inc · Houma, LABuilt 1979 · S/N 32-7940090 N30069Sky Pilot Aviation Corp · Carlsbad, CABuilt 1978 · S/N 32-7840195 N300DBEdeair LLC · Utica, MIBuilt 1979 · S/N 32-7940155 N300DLSanta Barbara Flying Club · Santa Barbara, CABuilt 1978 · S/N 32-7840200 N300DTAlaska Bush Charters LLC · Dillingham, AKBuilt 1978 · S/N 32-7840174 N300HVBaja Flyers Corp Inc · San Diego, CABuilt 1971 · S/N 32-7140026 N300JPRedd James P Trustee · Eureka, CABuilt 1969 · S/N 32-40597 N300RMHiscall Enterprises Inc · Dickson, TNBuilt 1970 · S/N 32-7140003 N3010TBb Air Corp · Tulsa, OKBuilt 1979 · S/N 32-7940060 N3011KBravo Farm LLC · Dover, DEBuilt 1978 · S/N 32-7940023 N3011XHanania-Stout Motorcars LLC · Chattanooga, TNBuilt 1979 · S/N 32-7940093 N3012LCwp Flight LLC · Lawton, OKBuilt 1979 · S/N 32-7940031 N3014XReasoner Michael L · Corvallis, ORBuilt 1979 · S/N 32-7940094 N3016NParker James C · Rescue, CABuilt 1979 · S/N 32-7940038 N301CAFreiday Robert A · Kingman, AZBuilt 1967 · S/N 32-40178 N301KKBurris Timothy J · Fountain Inn, SCBuilt 1979 · S/N 32-7940092 N301PKHubbs Matthew · Huntersville, NCBuilt 1973 · S/N 32-7440064 N3042UAnderson Jacob P · Cleveland, TNBuilt 1979 · S/N 32-7940078 N3043YAll Aviation LLC · Wilmington, DEBuilt 1979 · S/N 32-7940101 N3044KPetersen Alexander M · Laguna Beach, CABuilt 1979 · S/N 32-7940025 N3045KN3045k LLC · Belton, TXBuilt 1978 · S/N 32-7940026 N3051UPierson William Grant · Kerrville, TXBuilt 1979 · S/N 32-7940063 N3055RAll Sky Aviation LLC · Farmington, UTBuilt 1979 · S/N 32-7940053 N305MCShen Air II Inc · Mount Crawford, VABuilt 1973 · S/N 32-7340118 N3061WCcn Air LLC · Bloomington, INBuilt 1979 · S/N 32-7940079 N3062WD M Aviation II Llp · Park River, NDBuilt 1979 · S/N 32-7940080 N30697Rl Flyers LLC · Dover, DEBuilt 1978 · S/N 32-7840124 N306LTSteiner Glenn C · San Jose, CAFirst renewal noticeBuilt 1974 · S/N 32-7340111 N308DFCangiano Lorene D · Agua Dulce, CAS/N 32-7840015 N30919Callahan Aviation LLC · Clearwater, FLBuilt 1978 · S/N 32-7840125 N310EVMission Air Capital Services LLC · San Antonio, TXBuilt 1978 · S/N 32-7940024 N3132FN3132f LLC · Metairie, LABuilt 1973 · S/N 32-7440023 N31377Piercy Brian A · Kalispell, MTBuilt 1978 · S/N 32-7840126 N31380Aldred John B · Washoe Valley, NVBuilt 1978 · S/N 32-7840127 N31388Sisk Farms LLC · Hopkinsville, KYBuilt 1978 · S/N 32-7840128

Back to AD 74-18-13