Skip to content

Registered aircraft · 6,915

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:97-01-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:97-01-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:97-01-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:97-01-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:97-01-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:97-01-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.

N38448Orphans Hands Inc · Clinton, TNBuilt 1977 · S/N 32R-7780428 N38455Krenitsky Harrison J · Poland, OHBuilt 1977 · S/N 34-7770306 N38457Registration Pending · Phoenix, AZRegistration pendingBuilt 1977 · S/N 28R-7737094 N3845TBakrevski Lupcho · Valparaiso, INBuilt 1967 · S/N 28R-30165 N3846Osyka LLC · Sheridan, WYBuilt 1967 · S/N 28R-30167 N38468Emmons Kevin D · Vincennes, INBuilt 1977 · S/N 28R-7703225 N38476Bcdc Farms Inc · Sudan, TXS/N 32R-7780433 N3847TBay Air Inc · Bay City, MIBuilt 1967 · S/N 28R-30168 N38485Duke Kyle N · Laurel, MTS/N 28R-7703226 N38486Lone Tree Aero LLC · Lone Tree, COBuilt 1977 · S/N 28R-7703228 N3848TNextgen Flight Acacemy Inc · Riverside, CAS/N 28R-30169 N38495St Peter Christopher E · San Mateo, CABuilt 1977 · S/N 28R-7703229 N384NDJmfb Enterprises LLC · Concord, NCBuilt 2003 · S/N 2844095 N38509Fitzgerald Brady · St Augustine, FLBuilt 1977 · S/N 32R-7780435 N3851TSkyview Aviation LLC · Tracy, CABuilt 1967 · S/N 28R-30173 N3852TB & B Aircraft LLC · Norcross, GABuilt 1967 · S/N 28R-30174 N38538Jurecka Joseph W · Lubbock, TXBuilt 1977 · S/N 28R-7703237 N38539Sale Reported · KyivSale reportedBuilt 1977 · S/N 28R-7703238 N38555Grimm Chris · Burlington, IABuilt 1977 · S/N 28R-7703239 N38557Bowyer Ronald D · Keene, TXBuilt 1977 · S/N 28R-7703242 N3855TEskridge William M · Cheraw, SCBuilt 1967 · S/N 28R-30178 N38562Adventures Awaiting LLC · Rogers, ARBuilt 1977 · S/N 32R-7780442 N38564Ck Leasing Services LLC · Wilmington, DEBuilt 1977 · S/N 28R-7737097 N38565Olson Michael S · Ellsworth, KSFirst renewal noticeBuilt 1977 · S/N 28R-7737098 N3856TB & B Flying LLC · Huntingburg, INBuilt 1967 · S/N 28R-30179 N38575Hieb Jared · Amarillo, TXBuilt 1977 · S/N 32R-7780444 N3857TAmt Services LLC · Virginia Beach, VABuilt 1967 · S/N 28R-30180 N38587Swihart Painting LLC · Bolivar, MOBuilt 1977 · S/N 28R-7737100 N3858TFlying Dots LLC · Daytona Beach, FLBuilt 1967 · S/N 28R-30181 N38594Vineyard David D Md · South Lake, TXBuilt 1977 · S/N 28R-7703249 N38597Bad Dog Aviation Inc · Meridianville, ALBuilt 1977 · S/N 32R-7780445 N3859TYurek Allen L · Fairfax, VABuilt 1967 · S/N 28R-30182 N38605Registration Pending · Kalispell, MTRegistration pendingBuilt 1977 · S/N 28R-7737102 N3860TTds Property Holdings LLC · Gilmer, TXBuilt 1967 · S/N 28R-30183 N38610Whiskey Tango Foxtrot Aviation LLC · Broomfield, COS/N 28R-7703252 N38617Bros Flying Low LLC · Kalispell, MTS/N 32R-7780447 N38625Smith Mark S · Cornville, AZBuilt 1977 · S/N 34-7770329 N3862THanson John M · Wht Sphr Spgs, MTBuilt 1967 · S/N 28R-30185 N38632Tappan Michael L · Miamisburg, OHBuilt 1977 · S/N 28R-7737103 N38636Fre Investments LLC · Enterprise, ALBuilt 1977 · S/N 28R-7703253 N38639Mccullough Peter Lee · Doylestown, PABuilt 1977 · S/N 28R-7703255 N3864TPatton Aviation LLC · Billings, MTBuilt 1967 · S/N 28R-30187 N38655Wensmann Joel · Sartell, MNBuilt 1977 · S/N 28R-7737105 N38664Aerostyles LLC · Colorado Springs, COS/N 28R-7703259 N3866TVacracos James L · Saint John, INBuilt 1967 · S/N 28R-30189 N38674Tse Aircraft LLC · Jacksonville, FLBuilt 1977 · S/N 32R-7780459 N38679Bwt Aviation LLC · Montgomery, ALBuilt 1977 · S/N 34-7770332 N3867TSater Travis D · Salem, ORBuilt 1967 · S/N 28R-30190 N3869TSix Niner Tango LLC · Spartanburg, SCBuilt 1967 · S/N 28R-30193 N38701Sefton James Patrick · Carolina Beach, NCBuilt 1977 · S/N 28R-7703260

Back to AD 97-01-01 R1