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.

N4956DSorbi Aviation Inc · El Cajon, CABuilt 1979 · S/N 17272410 N4956VRegistered aircraftBuilt 1980 · S/N 172RG0425 N4958VFrank John M Jr · Alexandria, VABuilt 1980 · S/N 172RG0427 N4959VCutlass Cruisers Inc · Howard Lake, MNBuilt 1980 · S/N 172RG0428 N495EREmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 2019 · S/N 172S12270 N495SPFlying Start Aero Services LLC · Reno, NVBuilt 1998 · S/N 172S8036 N4960RUnited States Air Force Owner · Cannon Afb, NMBuilt 1967 · S/N 17256296 N4961GGardner Clifton T · Vernal, UTBuilt 1979 · S/N 17273508 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 N4964GCrotts Aircraft Service Inc · Dodge City, KSBuilt 1979 · S/N 17273511 N4966GSonger Charles W III · Tuscaloosa, ALBuilt 1979 · S/N 17273513 N4969ECapricorn Equipment Co · Madisonville, KYBuilt 1978 · S/N 17271685 N4969GSanford Aircraft LLC · Winter Springs, FLBuilt 1979 · S/N 17273516 N4969RUnited States Air Force Owner · Offutt Afb, NEBuilt 1967 · S/N 17256323 N496EREmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 2019 · S/N 172S12271 N496HMTalon Air Service Inc · Soldotna, AKBuilt 1976 · S/N 17267496 N496SPWingsleasing LLC · Wichita, KSBuilt 1998 · S/N 172S8037 N4971FRegistration Pending · Cottonwood, CARegistration pendingBuilt 1979 · S/N 17273110 N4971GSuper Hawk Inc · West Jordan, UTBuilt 1979 · S/N 17273518 N4971RScherer Sid S · Napa, CABuilt 1967 · S/N 17256325 N4971VGorman John Scott · Homosassa, FLBuilt 1980 · S/N 172RG0436 N4972GMcchuck Properties LLC · Pensacola, FLBuilt 1979 · S/N 17273519 N4972RUnited States Air Force · Apo, APBuilt 1967 · S/N 17256326 N4973FBoraam Aviation Inc · Prospect Heights, ILBuilt 1979 · S/N 17273111 N4974GPea-Wayman Flight LLC · Daytona Beach, FLBuilt 1979 · S/N 17273521 N4974RMcpherson Marvan T · Oklahoma City, OKS/N 17256328 N4975FFg Aviation LLC · La Jolla, CABuilt 1979 · S/N 17273112 N4975GBermuda Dunes Flight Training LLC · Palm Desert, CABuilt 1979 · S/N 17273522 N4975VMiller David M · Fort Worth, TXBuilt 1980 · S/N 172RG0440 N4976FLytle John A · Anaheim, CABuilt 1980 · S/N 172-73113 N4976GOklahoma Airmen Flying Club Inc · Jenks, OKS/N 17273523 N4976VPlane Fun Inc Tr Trustee · Snellville, GABuilt 1980 · S/N 172RG0441 N4978GJin Jin Aviation LLC · Anchorage, AKBuilt 1979 · S/N 17273525 N4978VGeorgeson Troy D · Sheyenne, NDBuilt 1980 · S/N 172RG0442 N4979RUnited States Air Force · Offutt Afb, NEBuilt 1967 · S/N 17256333 N4979VRobertson Roy E · Marion, IABuilt 1980 · S/N 172RG0443 N497ERPlane Three Ltd · Wilmington, DEBuilt 1998 · S/N 17280673 N497RAMartin Anthony M · Beebe, ARBuilt 1967 · S/N 17256273 N497SJFxe Flightcenter Corp · Fort Lauderdale, FLBuilt 2000 · S/N 172S8497 N497TCPinnacle Aviation Services Inc · Encinitas, CABuilt 2005 · S/N 172S9870 N4981GGillespie John · Austin, TXBuilt 1979 · S/N 17273528 N4981RUnited States Air Force (Owner) · Offutt Afb, NEBuilt 1967 · S/N 17256335 N4981VWasatch Industries LLC · Ogden, UTS/N 172RG0444 N4982EDevrnja Aero LLC · Knoxville, TNBuilt 1978 · S/N 17271686 N4983FSkyventure Avaition LLC · Battle Creek, MIS/N 17273115 N4983GBrouillard Mark R · Avon, INBuilt 1979 · S/N 17273530 N4983RAmerican Flight Museum · Topeka, KSS/N 17256337 N4985RUnited States Air Force Owner · Clovis, NMBuilt 1967 · S/N 17256339

Back to AD 90-06-03 R1