Skip to content

Registered aircraft · 20,683

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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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.

N479EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2015 · S/N 172S11601 N479NTFlight World Inc · San Juan, PRBuilt 1975 · S/N 17265279 N479SPRegistered aircraftBuilt 1998 · S/N 172S8024 N47AFL & J Aviation Inc · Atwater, CABuilt 2001 · S/N 17281041 N47GFGlobal Flight Support And Sales Inc · Tampa, FLBuilt 1997 · S/N 17280161 N47TNFlight Operations Aircraft LLC · Wilmington, DEBuilt 2005 · S/N 172S9996 N4800GPavco Inc · Gig Harbor, WAS/N 17273348 N4800VRegistered aircraftBuilt 1980 · S/N 172RG0382 N4801GFrederick Aero Development Inc · Murrieta, CAS/N 17273349 N4802GSky Warrior Flight Training LLC · Pensacola, FLS/N 17273350 N4803GAarow Aircraft Leasing LLC · Mcminnville, ORBuilt 1979 · S/N 17273351 N4804EPrestar Inc · Davis, CABuilt 1978 · S/N 17271665 N4805GTidewater Flying Club Inc · Newport News, VABuilt 1979 · S/N 17273353 N4805VBudulas Peter Panagiotis · Laurel, MDBuilt 1980 · S/N 172RG0384 N4806GStone Howard L · Pine Mountain, GABuilt 1979 · S/N 17273354 N4807DRussell Matthew D · Chattaroy, WAS/N 17272363 N4807GAdnd LLC · New Ipswich, NHBuilt 1979 · S/N 17273355 N4807JNew England Aviation LLC · Plainville, CTBuilt 1979 · S/N 17273680 N4808DLmnb LLC · Centreville, VABuilt 1979 · S/N 17272364 N4808FYankee Flying Club Inc · Maple Grove, MNBuilt 1979 · S/N 17273084 N4808GClub Aero Inc · Grand Rapids, OHS/N 17273356 N480ERFlying Off Leash Aviation LLC · Daniel Island, SCBuilt 1998 · S/N 17280624 N480SPDhs Operations LLC · Wilmington, DEBuilt 1998 · S/N 172S8025 N4810GAndrecheck Cynthia R · Bethel, AKBuilt 1979 · S/N 17273358 N4811GPoplar Grove Airmotive Inc · Poplar Grove, ILBuilt 1979 · S/N 17273359 N4811JSeals Kenneth P · Munford, ALBuilt 1979 · S/N 17273681 N4813CCivil Air Patrol · Maxwell Afb, ALBuilt 1985 · S/N 17276505 N4813GBasso Michele · Millbrook, ALBuilt 1979 · S/N 17273361 N4814CKingsky Flight Academy LLC · Lakeland, FLBuilt 1982 · S/N 17275868 N4814DAir Puerto Rico Corp · Aguadilla, PRBuilt 1979 · S/N 17272366 N4815CSt Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1985 · S/N 17276453 N4816VCollins Lisa A · Lake Dallas, TXBuilt 1980 · S/N 172RG0388 N4818DBald Eagle Flying Club · South Portland, MEBuilt 1979 · S/N 17272367 N4819GVeer Aviation Tx LLC · Houston, TXBuilt 1979 · S/N 17273367 N481EREmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 2019 · S/N 172S12250 N4820DBledsoe Duane C · Glendale, AZBuilt 1979 · S/N 17272369 N4820GAckerman Garry · Plano, TXBuilt 1979 · S/N 17273368 N4822GHighpoint Strategies LLC · Cypress, TXBuilt 1979 · S/N 17273370 N4823VStratus Air LLC · New Orleans, LAFirst renewal noticeBuilt 1980 · S/N 172RG0391 N4824GHickman Robert B · La Follette, TNBuilt 1979 · S/N 17273372 N4828PFlying Nam LLC · Sheridan, WYBuilt 1981 · S/N 17274828 N4829GSoaring Raven LLC · Seattle, WABuilt 1979 · S/N 17273377 N482CSTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13482 N482EHb Coco & Company · Gonzales, TXBuilt 1979 · S/N 17272338 N482EREmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 2019 · S/N 172S12252 N482SPArq Aviation LLC · Wilmington, NCBuilt 1998 · S/N 172S8028 N4830GHawaii Pacific Aviation Inc · Kailua Kona, HIBuilt 1979 · S/N 17273378 N48317Rhoden Gregory L · Sarasota, FLBuilt 1967 · S/N R172-0051 N4834ESweeney Michael J · Seattle, WABuilt 1978 · S/N 17271670 N4835GFiedler Aviation LLC · Suffolk, VABuilt 1979 · S/N 17273383

Back to AD 90-06-03 R1