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.

N6470BSchlotte Randall V · River Falls, WIBuilt 1957 · S/N 29670 N6470ETaft Ernest F · Sunburst, MTBuilt 1959 · S/N 46570 N6471BCarney Calvin W · Portland, TNBuilt 1957 · S/N 29671 N6471EFratangelo Patricia L · Trumansburg, NYBuilt 1959 · S/N 46571 N64728Systir Aviation LLC · Pittsburgh, PABuilt 1982 · S/N 17275612 N6472EWomack Terry W · Prineville, ORS/N 46572 N64736American Patrols Inc · Midland, TXBuilt 1982 · S/N 17275615 N64739Registered aircraftBuilt 1982 · S/N 17275616 N6473BGriffin Robert T Jr · Scranton, PABuilt 1957 · S/N 29673 N6473DTurner Glenn · West Melbourne, FLS/N 17272822 N64754Aerofeather Aviation Inc · Suffolk, VABuilt 1982 · S/N 17275617 N6475DDarcy Aviation LLC · Danbury, CTBuilt 1979 · S/N 17272823 N6476GChupito Sabrocito LLC · Paso Robles, CABuilt 1979 · S/N 17273601 N64776Christiansen Aviation LLC · Wilmington, DEBuilt 1982 · S/N 17275621 N6477ELoutzenhiser Mark · Wasilla, AKBuilt 1959 · S/N 46577 N6478BKuhfahl Matthew J · San Antonio, TXBuilt 1957 · S/N 29678 N6478DBrezovich Ivan A · Birmingham, ALBuilt 1979 · S/N 17272826 N64791Tfa Aircraft Holding Corp · Daytona Beach, FLBuilt 1982 · S/N 17275624 N64792Air Sal Leasing Inc · Fort Myers, FLS/N 17275625 N6479EThomas Alan R · Wickenberg, AZBuilt 1959 · S/N 46579 N647CRChristiansen Aviation LLC · Wilmington, DEBuilt 2015 · S/N 172S11613 N647CSTextron Aviation Inc · Wichita, KSS/N 172S13647 N647MTArbo Elijah B · Mount Chase, MEBuilt 1970 · S/N 17259158 N647SPElizabeth City State University · Elizabeth City, NCBuilt 1998 · S/N 172S8054 N647THChristiansen Aviation LLC · Wilmington, DEBuilt 2021 · S/N 172S12647 N6480BCrowe Manoah R · Del Valle, TXFirst renewal noticeBuilt 1957 · S/N 29680 N6480DFlyright Aviation LLC · North Las Vegas, NVBuilt 1979 · S/N 17272828 N64814Propel Air LLC · Pottstown, PABuilt 1982 · S/N 17275630 N64815Channel Islands Aviation Inc · Camarillo, CABuilt 1982 · S/N 17275631 N6481BMorse Cory L · Montville, MEBuilt 1957 · S/N 29681 N6481JCape Flight Instruction Inc · Cotuit, MABuilt 1980 · S/N 17273876 N6482BMendoza Victor · Liberal, KSS/N 29682 N6482EIreland Kel · Fredericksburg, TXBuilt 1959 · S/N 46582 N64834Golden Mahalo LLC · Sheridan, WYBuilt 1982 · S/N 17275632 N64859Leyva Maria · New Smyrna Beach, FLBuilt 1982 · S/N 17275636 N6485EWitte Steven E · Egan, SDBuilt 1959 · S/N 46585 N64866Universal Aviators Academy Inc · El Monte, CABuilt 1982 · S/N 17275639 N6486BDevine Aviation LLC · Atlanta, GABuilt 1956 · S/N 29686 N6486JSpredemann Carl A · Emmett, IDBuilt 1980 · S/N 17273877 N64875Air America Flight Center LLC · Daytona Beach, FLBuilt 1982 · S/N 17275642 N6487BOneal Gary · Springdale, ARBuilt 1957 · S/N 29687 N6487DWayne County Airport Board · Monticello, KYBuilt 1979 · S/N 17272831 N64882Blue Sky Flyers Inc · Greeley, COBuilt 1982 · S/N 17275643 N6488EDanielson Austin Mb · Kenai, AKBuilt 1959 · S/N 46588 N6488VThree Mayhoods LLC · Bonita Springs, FLS/N 172RG0725 N64892Montgomery Flying Club Inc · Montgomery, ALBuilt 1982 · S/N 17275644 N6489EDupuis Normand G · Berlin, NHBuilt 1959 · S/N 46589 N648CPCivil Air Patrol · Maxwell Afb, ALBuilt 2021 · S/N 172S12624 N648SPHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1998 · S/N 172S8055 N64901Gwaviation Consulting LLC · Woodstock, GABuilt 1974 · S/N 17262428

Back to AD 90-06-03 R1