Skip to content

Registered aircraft · 25,369

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-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.

N761LAIowa Lakes Community College · Estherville, IABuilt 1976 · S/N 172-67476 N761UAFirst Wings LLC · Sayre, PAS/N A1520986 N761YEUnique Educational Experiences Inc · Signal Hill, CABuilt 1981 · S/N A1520997 N7620GDc Aero LLC · Ramona, CABuilt 1970 · S/N 17259320 N7621GCrewdawg Aviation LLC · Concord, NCBuilt 1970 · S/N 17259321 N7621SSmith Michael D · King George, VABuilt 1976 · S/N 244-76 N7622GBell Sky Pilots Inc · Reedley, CABuilt 1970 · S/N 17259322 N7623GPlane Sane Aero LLC · Cary, NCBuilt 1970 · S/N 17259323 N7623SKrejchik Daniel J · Portage, WIS/N 925-76 N7623VGove Richard · Riverside, CAFirst renewal noticeBuilt 1976 · S/N 177RG0892 N7624GAeroflight Flying Club Inc · Jackson, TNBuilt 1970 · S/N 17259324 N7624SHovey Gregg Beecher · San Diego, CABuilt 1976 · S/N 207-76 N7625SN4457s LLC · Southport, NCBuilt 1976 · S/N 330-76 N7627SJohnson Richard M · Osceola, WIBuilt 1976 · S/N 1163-76 N7629GDodd Dennis R · Collinsville, OKBuilt 1970 · S/N 17259329 N762JSSayers James B · Edison, OHBuilt 1981 · S/N A1520970 N762KGDickens Randy L · Fuquay Varina, NCBuilt 2002 · S/N 469-2002 N7630SKidd Alan E Trustee · Louisburg, KSBuilt 1976 · S/N 209-76 N7631GChickadee Aviation LLC · Rangeley, MEBuilt 1970 · S/N 17259331 N7632SLocker Don D · Muleshoe, TXBuilt 1976 · S/N 575-76 N7633SSageeyah Citabria LLC · Claremore, OKBuilt 1976 · S/N 1164-76 N7635SMcgaughy Robert E · Snow Hill, NCBuilt 1976 · S/N 248-76 N7636GDurham Ranches Inc · Gillette, WYBuilt 1970 · S/N 17259336 N7636SPrt Aviation LLC · Port Orange, FLBuilt 1976 · S/N 1165-76 N7637GEverett Flying Service Inc · Holly Grove, ARBuilt 1970 · S/N 17259337 N7637VRamsey Brian S · Monument, COBuilt 1976 · S/N 177RG0898 N76382Registered aircraftBuilt 1976 · S/N 576-76 N7638GMoseley Michael S · Chelsea, ALBuilt 1970 · S/N 17259338 N763GLUzyn Jerry J · Lafayette, INBuilt 1977 · S/N 0763 N763SASunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 15283073 N7640GCreative Strategies Inc · Proctorville, OHBuilt 1970 · S/N 17259340 N7642GAir Petunia · Claremont, CABuilt 1970 · S/N 17259342 N7643GTriad Aviation Academy LLC · Greensboro, NCBuilt 1970 · S/N 17259343 N7644GSkypark Inc · Wadsworth, OHBuilt 1970 · S/N 17259344 N7645VBig Sky Aviation Leasing LLC · Helena, MTBuilt 1976 · S/N 177RG0899 N7646GSky Aviation LLC · Encinitas, CABuilt 1970 · S/N 17259346 N7647GIowa Lakes Community College · Estherville, IAS/N 17259347 N764AAWings Over Texas Holdings LLC · Denton, TXBuilt 1975 · S/N 17265624 N764APSale Reported · Kaplan, LASale reportedBuilt 1978 · S/N 38-78A0706 N764BKFairmont State University · Fairmont, WVBuilt 1976 · S/N 17266891 N764RBReo & Bpo LLC · Lewes, DEBuilt 1982 · S/N 21064674 N7650SMoore Aviation LLC · Westminster, COBuilt 1976 · S/N 928-76 N7653STow Plane Idaho LLC · Boise, IDBuilt 1976 · S/N 212-76 N7658SFlytwincos LLC · Las Vegas, NVBuilt 1976 · S/N 251-76 N765ACAllen Steven J · Pewee Valley, KYBuilt 1999 · S/N 1269-99 N765GLCroll H Robert III · Jacksonville, ORS/N 0765 N7660GKorn Clifton A · Hayward, WIBuilt 1970 · S/N 17259360 N7662GB&R Aircraft LLC · Wadsworth, OHBuilt 1970 · S/N 17259362 N7664SPekarek Robert K · Buda, TXBuilt 1976 · S/N 588-76 N7665SPiercy Ronald S · Moses Lake, WAS/N 331-76

Back to AD 80-25-07 R1