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.

N5017AMeixell David Matthew · Santa Maria, CABuilt 1955 · S/N 28017 N5017RR&R Leasing LLC · Fargo, NDBuilt 1974 · S/N 17263258 N5018ABadger Daniel J · Yellow Springs, OHS/N 28018 N50193Folsom Gary A · Marianna, FLBuilt 1974 · S/N 17264196 N501ERVista Air Inc · Pacoima, CABuilt 2001 · S/N 172S8947 N501MPManzoor Khan · Stockton, CABuilt 1978 · S/N 17270318 N501SCSaz Dynamics LLC · Daly City, CABuilt 2005 · S/N 172S9883 N501TSFlying Tigers Flight School LLC · Houston, TXBuilt 1976 · S/N 17266839 N50208Haus Jesse M · Fort Worth, TXBuilt 1974 · S/N 17264197 N5020HBorreson Anthony · Mariposa, CABuilt 1975 · S/N 17265303 N5020RMigliaccio Jason · Palm Bay, FLBuilt 1974 · S/N 17263261 N5021HAlamo Flyers LLC · Elmendorf, TXBuilt 1975 · S/N 17265304 N5021RWax Sally G · Louisville, KYBuilt 1974 · S/N 17263262 N5023JTexas State Technical College · Waco, TXBuilt 2001 · S/N 172S8964 N5023RStern Joseph L · Morrow, OHBuilt 1974 · S/N 17263264 N5024ADucharme Matthew B · Harlem, GABuilt 1955 · S/N 28024 N5026RSwinney Marty Sherman Trustee · Macomb, OKBuilt 1974 · S/N 17263267 N5027RVentura Hector E · Vieques, PRS/N 17263268 N5028AVonszilassy Peter · Fredericksburg, VABuilt 1955 · S/N 28028 N50291Euros Aircraft Leasing LLC · College Station, TXBuilt 1974 · S/N 17264199 N502ERZoeing Lease Inc · Lewes, DEBuilt 1998 · S/N 172S8002 N502TMDraco Flight School Inc · Chino, CABuilt 1975 · S/N 17265893 N5030BInternational Air Services Inc Trustee · Carson City, NVBuilt 2009 · S/N 172S10887 N5031AEggum Jeramy J · Puyallup, WABuilt 1955 · S/N 28031 N5033AAloof Aviation LLC · Denver, COBuilt 1955 · S/N 28033 N5033REastern Cincinnati Aviation Inc · Batavia, OHBuilt 1974 · S/N 17263274 N5034HHernandez Dorothy V · Juneau, AKBuilt 1975 · S/N 17265309 N5035MFlight World Inc · San Juan, PRBuilt 2001 · S/N 172S8967 N5035XAtlantic Arrow Aircraft Inc · Kennesaw, GABuilt 2026 · S/N 172S13522 N5037RJlinn Aviation Inc · Quinlan, TXBuilt 1974 · S/N 17263278 N5039ASutton Aircraft Salvage LLC · Palmer, AKBuilt 1955 · S/N 28039 N5039HBig Mountain Aviation Inc · Whitefish, MTBuilt 1975 · S/N 17265311 N5039RSmooth Landings Inc · Cary, ILBuilt 1974 · S/N 17263280 N503AMAlpha Aviation LLC · Spartanburg, SCBuilt 1982 · S/N 17275767 N503CAThompson Paul W Jr · Yachats, ORBuilt 1974 · S/N 17263757 N503ETar Dennis W · Summerfield, NCBuilt 1956 · S/N 28361 N503MAHobart Aviation Inc · Akron, OHBuilt 1975 · S/N 17266089 N503SPNew Horizon Aviation Inc · Warwick, RIBuilt 1998 · S/N 172S8040 N503WAThree Rivers Aero Inc · Three Rivers, MIBuilt 1975 · S/N 17265025 N5040APark Kyle Hunter · Jefferson City, MOS/N 28040 N5040RShirley Craig T · Ennis, MTBuilt 1974 · S/N 17263281 N5041AMccollough Bruce S · Skandia, MIBuilt 1955 · S/N 28041 N5041EApm Leasing LLC · Casper, WYS/N 17271696 N5041HSimplifly LLC · Mesa, AZBuilt 1975 · S/N 17265313 N5042RLemieux Michael H · Methuen, MABuilt 1974 · S/N 17263283 N5043AStephens Zachary L · Big Lake, AKS/N 28043 N5043JValiair Lc Trustee · Casper, WYBuilt 2008 · S/N 172S10861 N5043RRegistered aircraftBuilt 1974 · S/N 17263284 N5044APatzanakidis Konstandinos · Jupiter, FLBuilt 1955 · S/N 28044 N5044EAviation Needs LLC · Stapleton, NEBuilt 1978 · S/N 17271698

Back to AD 90-06-03 R1