Skip to content

Registered aircraft · 40,473

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-04-03-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:80-04-03-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:80-04-03-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:80-04-03-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:80-04-03-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:80-04-03-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.

N4953VMccreery Aviation Co Inc · Mcallen, TXBuilt 1980 · S/N 172RG0423 N4954FGq Aviation LLC · Cherry Hill, NJBuilt 1976 · S/N 28-7715086 N4954GKris Noone Air LLC · Wilmington, DEBuilt 1979 · S/N 17273501 N4954LSavoie John P · Jal, NMBuilt 1967 · S/N 28-4325 N4955DBerman David M · Charlotte, NCBuilt 1979 · S/N 17272409 N4955LDakan John M · Hemet, CABuilt 1967 · S/N 28-4326 N4956DSorbi Aviation Inc · El Cajon, CABuilt 1979 · S/N 17272410 N4956VRegistered aircraftBuilt 1980 · S/N 172RG0425 N4957EKuckkahn Dale P · Lake Tomahawk, WIS/N 22-4222 N4957LButler Cole A · Snowflake, AZBuilt 1967 · S/N 28-4328 N4958FJuoni Joshua Charles · Oklahoma City, OKBuilt 1976 · S/N 28-7790078 N4958LOgren James A · De Smet, SDBuilt 1968 · S/N 28-5007 N4958VFrank John M Jr · Alexandria, VABuilt 1980 · S/N 172RG0427 N4959LFly Cht LLC · Chillicothe, MOBuilt 1967 · S/N 28-4330 N4959VCutlass Cruisers Inc · Howard Lake, MNBuilt 1980 · S/N 172RG0428 N495ABRayburn Jason A · Gibbon, NEBuilt 2008 · S/N 22638 N495ACRegistration Pending · Honolulu, HIRegistration pendingBuilt 1999 · S/N 1265-99 N495DBWolfson Jason · Duxbury, MABuilt 1995 · S/N 372-95 N495FLUrban Thomas L · Glencoe, MNBuilt 1971 · S/N 28-7125310 N495PLIntegrity Aircraft Title Holdings LLC · Portland, ORS/N 3011M N495TMMacdonald Kenneth A · Willow, AKBuilt 1980 · S/N 18-8109001 N4960LWynn Wora A · Scottsdale, AZBuilt 1967 · S/N 28-4331 N4961GGardner Clifton T · Vernal, UTBuilt 1979 · S/N 17273508 N4961KGirolami Philip · Fircrest, WABuilt 1977 · S/N 20-1232 N4961LKral Aircraft LLC · Ocala, FLBuilt 1967 · S/N 28-4332 N4961THatami-Nezhad Jamshid · Encino, CABuilt 1972 · S/N 28-7225289 N4961YSprenger Michael T · Hawley, MNBuilt 1973 · S/N 18-7309020 N4962GVersteeg Martin · San Antonio, TXBuilt 1979 · S/N 17273509 N4962VAircraft Partner Holdings Inc Trustee · BerlinBuilt 1980 · S/N 172RG0430 N4963GSunwest Aviation Inc · Santa Ynez, CABuilt 1979 · S/N 17273510 N4963LBakk Dale A · Nikiski, AKBuilt 1967 · S/N 28-4334 N4964GCrotts Aircraft Service Inc · Dodge City, KSBuilt 1979 · S/N 17273511 N4964LMcallister Robert G · Santee, CABuilt 1967 · S/N 28-4335 N4965LCentral Air Parts Inc · Staunton, ILS/N 28-4336 N4966GSonger Charles W III · Tuscaloosa, ALBuilt 1979 · S/N 17273513 N4966LNelson Osea C · Sheridan, WYBuilt 1967 · S/N 28-4337 N4967NKubinski Kenneth B · Eastover, NCS/N 790066LF N4968LSchoolcraft William F · Middletown, OHBuilt 1967 · S/N 28-4339 N4969ECapricorn Equipment Co · Madisonville, KYBuilt 1978 · S/N 17271685 N4969GSanford Aircraft LLC · Winter Springs, FLBuilt 1979 · S/N 17273516 N4969LLubnau Berdy G · New Braunfels, TXBuilt 1967 · S/N 28-4341 N496DSDelaware State University · Dover, DEBuilt 1993 · S/N 2816105 N496ECHatfield James D · Hagerman, IDBuilt 2004 · S/N 1356-2003 N496MGRippy Gregg P · Glenwood Springs, COBuilt 1992 · S/N 1213 N496TPVertical Corporation · Kalispell, MTBuilt 1991 · S/N 1646 N496WWestern Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1931 · S/N 2023 N4970LAzflyers LLC · Gilbert, AZBuilt 1967 · S/N 28-4344 N4971FRegistration Pending · Cottonwood, CARegistration pendingBuilt 1979 · S/N 17273110 N4971GSuper Hawk Inc · West Jordan, UTBuilt 1979 · S/N 17273518 N4971LNathanson David · Los Angeles, CAS/N 28-4345

Back to AD 80-04-03 R2