Skip to content

Registered aircraft · 81,733

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.

N3957MCarnahan Thomas L · Wasilla, AKBuilt 1947 · S/N 12-2856 N3957QRwm Aviation LLC · Kalispell, MTBuilt 1971 · S/N 17260057 N3957RHaushold Aviation LLC · Shelbyville, TNBuilt 1970 · S/N 28-7105062 N3957WPorter Casey · Bluffton, SCBuilt 1967 · S/N 32-906 N3957ZAlsworth Leon R · Port Alsworth, AKBuilt 1962 · S/N 18-7818 N3958KArias Benjamin H · Fort Stockton, TXBuilt 1967 · S/N 28-23837 N3958PHoward Kevin B · Plymouth, MIBuilt 1956 · S/N 22-3636 N3958QFisher Gregory S · Franklin, WIBuilt 1971 · S/N 17260058 N3958TPiowaty Craig M · Hilo, HIBuilt 1967 · S/N 28R-30303 N3958ZWelstad Blaine L · Newburg, NDBuilt 1962 · S/N 18-7819 N3959KPuertola Pascual G · Cobb, CAS/N 28-23838 N3959RBederov Alex · Redwood City, CABuilt 1970 · S/N 28-7105064 N3959XCavanaugh Brian L · Manitowoc, WIBuilt 1975 · S/N 28-7625001 N3959ZDld Corp · Ogden, UTBuilt 1962 · S/N 18-7821 N395CVCivil Air Patrol · Maxwell Afb, ALBuilt 2016 · S/N 18282434 N395DNational Training 1 LLC · Wilmington, DEBuilt 2016 · S/N 2843859 N395HPGarza David Javier · Mcallen, TXBuilt 1994 · S/N 3213085 N395HZPilot In Command LLC · Parker, COBuilt 1992 · S/N 492 N395JPKane Aviation LLC · Salem, VABuilt 2004 · S/N 40.410 N395LAZapel Theodore O · Colorado Springs, COBuilt 1967 · S/N 28-23836 N395MAEzelle Stephen · Savannah, GABuilt 1995 · S/N 2811044 N395MTCubi Erik O · Chicopee, MABuilt 1967 · S/N 28-23834 N395SPTexas State Technical College · Waco, TXBuilt 1999 · S/N 172S8292 N395TCAqz Aviation Inc Trustee · Wilmington, DEBuilt 1995 · S/N 20003 N395THChristiansen Aviation LLC · Wilmington, DEBuilt 1980 · S/N 17274174 N395XRegistration Pending · Marion, MTRegistration pending, pending cancellationBuilt 1976 · S/N 7037C N39600Inlet Shores Aviation LLC · Ponce Inlet, FLBuilt 1978 · S/N 32-7840169 N39609G Medical LLC · Cedar Falls, IABuilt 1978 · S/N 28-7890542 N3960KRegistration Pending · Roanoke, TXRegistration pendingBuilt 1967 · S/N 28-23839 N3960MBales Gregory W · Enterprise, ORBuilt 1947 · S/N 12-2843 N3960QLastochka LLC · Kalispell, MTBuilt 1971 · S/N 17260060 N3960RLong William R · Jackson, TNBuilt 1971 · S/N 28-7105065 N3960TThompson Jerry C · Goldsboro, NCBuilt 1968 · S/N 28R-30305 N3960WTaylor Ryan · Lakeland, FLBuilt 1967 · S/N 32-939 N3961Aero Black LLC · Wheat Ridge, COBuilt 1974 · S/N 563EP N39610Archer Aviation LLC · Pittsburg, KSBuilt 1978 · S/N 28-7890543 N3961MBluebird Aviation LLC · Bismarck, NDBuilt 1978 · S/N 28-7816392 N3961PMcquivey David · St George, UTS/N 22-3639 N3961RWhite Lightning 3961r LLC · Chandler, AZBuilt 1971 · S/N 28-7105066 N3961TMartin Noah R · Newcastle, CABuilt 1967 · S/N 28R-30306 N39621Zulu Aircraft Leasing LLC · Grants Pass, ORBuilt 1978 · S/N 44-7995016 N39626Drm Air Group Inc · Lewes, DEBuilt 1978 · S/N 32-7840171 N3962KFolsom Lawrence E · Millington, MDBuilt 1967 · S/N 28-23842 N3962QKalstrom William M · Ekalaka, MTBuilt 1971 · S/N 17260062 N3962RNifong James · Enterprise, ALBuilt 1971 · S/N 28-7105067 N3962TSilvretta LLC · Kalispell, MTBuilt 1967 · S/N 28R-30307 N39633Sandusky Aviation LLC · Edmond, OKBuilt 1978 · S/N 28-7916001 N3963TBlessing Stephen L · Bethany, MOS/N 28R-30309 N3963ZMusgrove Jimmy Wayne · Delta Junction, AKBuilt 1962 · S/N 18-7826 N39647Pcl2 LLC · Menomonie, WIBuilt 1978 · S/N 32R-7885233

Back to AD 81-18-04 R2